2025-06-04 01:15:46,186 [ 362793 ] INFO : ClickHouse root is not set. Will use /home/ubuntu/_work/ClickHouse/ClickHouse (runner:42, check_args_and_update_paths) 2025-06-04 01:15:46,187 [ 362793 ] INFO : Cases dir is not set. Will use /home/ubuntu/_work/ClickHouse/ClickHouse/tests/integration (runner:86, check_args_and_update_paths) 2025-06-04 01:15:46,187 [ 362793 ] INFO : utils dir is not set. Will use /home/ubuntu/_work/ClickHouse/ClickHouse/utils (runner:97, check_args_and_update_paths) 2025-06-04 01:15:46,187 [ 362793 ] INFO : base_configs_dir: /home/ubuntu/_work/ClickHouse/ClickHouse/programs/server, binary: /home/ubuntu/_work/_temp/test/build/clickhouse, cases_dir: /home/ubuntu/_work/ClickHouse/ClickHouse/tests/integration (runner:99, check_args_and_update_paths) clickhouse_integration_tests_volume Running pytest container as: 'docker run --rm --name clickhouse_integration_tests_5ciz2o --privileged --dns-search='.' --volume=/home/ubuntu/_work/_temp/test/build/clickhouse-odbc-bridge:/clickhouse-odbc-bridge --volume=/home/ubuntu/_work/_temp/test/build/clickhouse:/clickhouse --volume=/home/ubuntu/_work/_temp/test/build/clickhouse-library-bridge:/clickhouse-library-bridge --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/programs/server:/clickhouse-config --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/tests/integration:/ClickHouse/tests/integration --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/utils/backupview:/ClickHouse/utils/backupview --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/utils/grpc-client/pb2:/ClickHouse/utils/grpc-client/pb2 --volume=/run:/run/host:ro --volume=clickhouse_integration_tests_volume:/var/lib/docker -e DOCKER_DOTNET_CLIENT_TAG=11de0b29a15d -e DOCKER_HELPER_TAG=2cffe1eae894 -e DOCKER_BASE_TAG=2993bc2bf171 -e DOCKER_KERBERIZED_HADOOP_TAG=ce74919e88f5 -e DOCKER_KERBEROS_KDC_TAG=9391ecdee8d7 -e DOCKER_MYSQL_GOLANG_CLIENT_TAG=9bec2a638e6e -e DOCKER_MYSQL_JAVA_CLIENT_TAG=766bff31cfe4 -e DOCKER_MYSQL_JS_CLIENT_TAG=41ba7c2ec2a1 -e DOCKER_MYSQL_PHP_CLIENT_TAG=88be89c1e3b6 -e DOCKER_NGINX_DAV_TAG=b55ac9cd7519 -e DOCKER_POSTGRESQL_JAVA_CLIENT_TAG=a4eff5c7f4d6 -e DOCKER_PYTHON_BOTTLE_TAG=a2d3dc777d0c -e DOCKER_CLIENT_TIMEOUT=300 -e COMPOSE_HTTP_TIMEOUT=600 -e CLICKHOUSE_USE_OLD_ANALYZER=1 -e PYTHONUNBUFFERED=1 -e PYTEST_ADDOPTS="--dist=loadfile -n 10 -rfEps --run-id=0 --color=no --durations=0 test_postgresql_replica_database_engine_1/test.py::test_replicating_dml test_postgresql_replica_database_engine_1/test.py::test_restart_server_while_replication_startup_not_finished test_postgresql_replica_database_engine_1/test.py::test_single_transaction test_postgresql_replica_database_engine_1/test.py::test_table_schema_changes test_postgresql_replica_database_engine_1/test.py::test_user_managed_slots test_postgresql_replica_database_engine_1/test.py::test_virtual_columns test_quota/test.py::test_add_remove_interval test_quota/test.py::test_add_remove_quota test_quota/test.py::test_consumption_of_show_clusters test_quota/test.py::test_consumption_of_show_databases test_quota/test.py::test_consumption_of_show_privileges test_quota/test.py::test_consumption_of_show_processlist test_quota/test.py::test_consumption_of_show_tables test_quota/test.py::test_dcl_introspection test_quota/test.py::test_dcl_management test_quota/test.py::test_exceed_quota test_quota/test.py::test_query_inserts test_quota/test.py::test_quota_from_users_xml test_quota/test.py::test_reload_users_xml_by_timer test_quota/test.py::test_simpliest_quota test_quota/test.py::test_tracking_quota test_quota/test.py::test_users_xml_is_readonly test_reloading_settings_from_users_xml/test.py::test_force_reload test_reloading_settings_from_users_xml/test.py::test_reload_on_timeout test_reloading_settings_from_users_xml/test.py::test_unexpected_setting_enum test_reloading_settings_from_users_xml/test.py::test_unexpected_setting_int test_reloading_settings_from_users_xml/test.py::test_unknown_setting_force_reload test_reloading_settings_from_users_xml/test.py::test_unknown_setting_reload_on_timeout test_render_log_file_name_templates/test.py::test_check_file_names test_replicated_merge_tree_compatibility/test.py::test_replicated_merge_tree_defaults_compatibility test_replicated_merge_tree_s3_zero_copy/test.py::test_drop_table 'test_replicated_merge_tree_s3_zero_copy/test.py::test_insert_select_replicated[0-16]' 'test_replicated_merge_tree_s3_zero_copy/test.py::test_insert_select_replicated[8192-12]' test_replicated_merge_tree_s3_zero_copy/test.py::test_s3_check_restore test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_create_replicated_merge_tree_with_auxiliary_zookeeper test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_create_replicated_merge_tree_with_default_zookeeper test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_create_replicated_merge_tree_with_not_exists_auxiliary_zookeeper test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_drop_replicated_merge_tree_with_auxiliary_zookeeper test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_path_ambiguity test_replicated_mutations/test.py::test_mutations 'test_replicated_mutations/test.py::test_mutations_dont_prevent_merges[nodes0]' 'test_replicated_mutations/test.py::test_mutations_dont_prevent_merges[nodes1]' test_replicated_user_defined_functions/test.py::test_create_and_drop 'test_replicated_user_defined_functions/test.py::test_create_and_drop_udf_on_cluster[false-expected_raise1]' 'test_replicated_user_defined_functions/test.py::test_create_and_drop_udf_on_cluster[true-expected_raise0]' test_replicated_user_defined_functions/test.py::test_create_and_replace test_replicated_user_defined_functions/test.py::test_drop_if_exists test_replicated_user_defined_functions/test.py::test_reload_zookeeper test_replicated_user_defined_functions/test.py::test_replication test_replicated_user_defined_functions/test.py::test_replication_replace_by_another_node_after_creation test_replicated_user_defined_functions/test.py::test_server_restart test_replicated_user_defined_functions/test.py::test_start_without_zookeeper 'test_replicated_users/test.py::test_create_and_delete_replicated[QUOTA]' 'test_replicated_users/test.py::test_create_and_delete_replicated[ROLE]' 'test_replicated_users/test.py::test_create_and_delete_replicated[ROW_POLICY]' 'test_replicated_users/test.py::test_create_and_delete_replicated[SETTINGS_PROFILE]' 'test_replicated_users/test.py::test_create_and_delete_replicated[USER]' 'test_replicated_users/test.py::test_create_replicated[QUOTA]' 'test_replicated_users/test.py::test_create_replicated[ROLE]' 'test_replicated_users/test.py::test_create_replicated[ROW_POLICY]' 'test_replicated_users/test.py::test_create_replicated[SETTINGS_PROFILE]' 'test_replicated_users/test.py::test_create_replicated[USER]' 'test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[QUOTA]' 'test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[ROLE]' 'test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[ROW_POLICY]' 'test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[SETTINGS_PROFILE]' 'test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[USER]' 'test_replicated_users/test.py::test_create_replicated_on_cluster[QUOTA]' 'test_replicated_users/test.py::test_create_replicated_on_cluster[ROLE]' 'test_replicated_users/test.py::test_create_replicated_on_cluster[ROW_POLICY]' 'test_replicated_users/test.py::test_create_replicated_on_cluster[SETTINGS_PROFILE]' 'test_replicated_users/test.py::test_create_replicated_on_cluster[USER]' 'test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[QUOTA]' 'test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[ROLE]' 'test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[ROW_POLICY]' 'test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[SETTINGS_PROFILE]' 'test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[USER]' 'test_replicated_users/test.py::test_grant_revoke_replicated[With_ignored_on_cluster]' 'test_replicated_users/test.py::test_grant_revoke_replicated[Without_on_cluster]' test_replicated_users/test.py::test_reload_zookeeper 'test_replicated_users/test.py::test_rename_replicated[QUOTA]' 'test_replicated_users/test.py::test_rename_replicated[ROLE]' 'test_replicated_users/test.py::test_rename_replicated[ROW_POLICY]' 'test_replicated_users/test.py::test_rename_replicated[SETTINGS_PROFILE]' 'test_replicated_users/test.py::test_rename_replicated[USER]' test_replicating_constants/test.py::test_different_versions test_replication_credentials/test.py::test_credentials_and_no_credentials test_replication_credentials/test.py::test_different_credentials test_replication_credentials/test.py::test_no_credentials test_replication_credentials/test.py::test_same_credentials test_s3_aws_sdk_has_slightly_unreliable_behaviour/test.py::test_dataloss test_s3_imds/test_session_token.py::test_credentials_from_metadata 'test_s3_with_https/test.py::test_s3_with_https[s3_secure]' 'test_s3_with_https/test.py::test_s3_with_https[s3_secure_with_proxy]' test_s3_zero_copy_ttl/test.py::test_ttl_move_and_s3 test_shutdown_wait_unfinished_queries/test.py::test_shutdown_wait_unfinished_queries test_ssh_keys_authentication/test.py::test_ecdsa test_ssh_keys_authentication/test.py::test_ed25519 test_ssh_keys_authentication/test.py::test_key_with_passphrase test_ssh_keys_authentication/test.py::test_key_with_wrong_passphrase -vvv" altinityinfra/integration-tests-runner:9d492c2eec24 '. Start tests ============================= test session starts ============================== platform linux -- Python 3.10.12, pytest-7.4.4, pluggy-1.5.0 -- /usr/bin/python3 cachedir: .pytest_cache rootdir: /ClickHouse/tests/integration configfile: pytest.ini plugins: order-1.0.1, random-0.2, timeout-2.2.0, repeat-0.9.3, reportlog-0.4.0, xdist-3.5.0 timeout: 900.0s timeout method: signal timeout func_only: False created: 10/10 workers 10 workers [100 items] scheduling tests via LoadFileScheduling test_replication_credentials/test.py::test_credentials_and_no_credentials test_postgresql_replica_database_engine_1/test.py::test_replicating_dml test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_create_replicated_merge_tree_with_auxiliary_zookeeper test_quota/test.py::test_add_remove_interval test_ssh_keys_authentication/test.py::test_ecdsa test_replicated_merge_tree_s3_zero_copy/test.py::test_drop_table test_reloading_settings_from_users_xml/test.py::test_force_reload test_replicated_user_defined_functions/test.py::test_create_and_drop test_replicated_users/test.py::test_create_and_delete_replicated[QUOTA] test_replicated_mutations/test.py::test_mutations [gw8] [ 1%] PASSED test_ssh_keys_authentication/test.py::test_ecdsa test_ssh_keys_authentication/test.py::test_ed25519 [gw8] [ 2%] PASSED test_ssh_keys_authentication/test.py::test_ed25519 test_ssh_keys_authentication/test.py::test_key_with_passphrase [gw8] [ 3%] PASSED test_ssh_keys_authentication/test.py::test_key_with_passphrase test_ssh_keys_authentication/test.py::test_key_with_wrong_passphrase [gw8] [ 4%] PASSED test_ssh_keys_authentication/test.py::test_key_with_wrong_passphrase [gw4] [ 5%] PASSED test_reloading_settings_from_users_xml/test.py::test_force_reload test_reloading_settings_from_users_xml/test.py::test_reload_on_timeout test_s3_with_https/test.py::test_s3_with_https[s3_secure] [gw4] [ 6%] PASSED test_reloading_settings_from_users_xml/test.py::test_reload_on_timeout test_reloading_settings_from_users_xml/test.py::test_unexpected_setting_enum [gw2] [ 7%] PASSED test_replicated_user_defined_functions/test.py::test_create_and_drop test_replicated_user_defined_functions/test.py::test_create_and_drop_udf_on_cluster[false-expected_raise1] [gw2] [ 8%] PASSED test_replicated_user_defined_functions/test.py::test_create_and_drop_udf_on_cluster[false-expected_raise1] test_replicated_user_defined_functions/test.py::test_create_and_drop_udf_on_cluster[true-expected_raise0] [gw1] [ 9%] PASSED test_quota/test.py::test_add_remove_interval test_quota/test.py::test_add_remove_quota [gw3] [ 10%] FAILED test_postgresql_replica_database_engine_1/test.py::test_replicating_dml [gw4] [ 11%] PASSED test_reloading_settings_from_users_xml/test.py::test_unexpected_setting_enum test_reloading_settings_from_users_xml/test.py::test_unexpected_setting_int [gw0] [ 12%] PASSED test_replicated_users/test.py::test_create_and_delete_replicated[QUOTA] test_replicated_users/test.py::test_create_and_delete_replicated[ROLE] [gw2] [ 13%] PASSED test_replicated_user_defined_functions/test.py::test_create_and_drop_udf_on_cluster[true-expected_raise0] test_replicated_user_defined_functions/test.py::test_create_and_replace [gw0] [ 14%] PASSED test_replicated_users/test.py::test_create_and_delete_replicated[ROLE] test_replicated_users/test.py::test_create_and_delete_replicated[ROW_POLICY] test_postgresql_replica_database_engine_1/test.py::test_restart_server_while_replication_startup_not_finished [gw0] [ 15%] PASSED test_replicated_users/test.py::test_create_and_delete_replicated[ROW_POLICY] test_replicated_users/test.py::test_create_and_delete_replicated[SETTINGS_PROFILE] [gw4] [ 16%] PASSED test_reloading_settings_from_users_xml/test.py::test_unexpected_setting_int test_reloading_settings_from_users_xml/test.py::test_unknown_setting_force_reload [gw0] [ 17%] PASSED test_replicated_users/test.py::test_create_and_delete_replicated[SETTINGS_PROFILE] test_replicated_users/test.py::test_create_and_delete_replicated[USER] [gw0] [ 18%] PASSED test_replicated_users/test.py::test_create_and_delete_replicated[USER] test_replicated_users/test.py::test_create_replicated[QUOTA] [gw2] [ 19%] PASSED test_replicated_user_defined_functions/test.py::test_create_and_replace test_replicated_user_defined_functions/test.py::test_drop_if_exists [gw4] [ 20%] PASSED test_reloading_settings_from_users_xml/test.py::test_unknown_setting_force_reload test_reloading_settings_from_users_xml/test.py::test_unknown_setting_reload_on_timeout [gw2] [ 21%] PASSED test_replicated_user_defined_functions/test.py::test_drop_if_exists test_replicated_user_defined_functions/test.py::test_reload_zookeeper [gw0] [ 22%] PASSED test_replicated_users/test.py::test_create_replicated[QUOTA] test_replicated_users/test.py::test_create_replicated[ROLE] [gw5] [ 23%] PASSED test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_create_replicated_merge_tree_with_auxiliary_zookeeper test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_create_replicated_merge_tree_with_default_zookeeper [gw0] [ 24%] PASSED test_replicated_users/test.py::test_create_replicated[ROLE] test_replicated_users/test.py::test_create_replicated[ROW_POLICY] [gw4] [ 25%] PASSED test_reloading_settings_from_users_xml/test.py::test_unknown_setting_reload_on_timeout [gw1] [ 26%] PASSED test_quota/test.py::test_add_remove_quota test_quota/test.py::test_consumption_of_show_clusters [gw0] [ 27%] PASSED test_replicated_users/test.py::test_create_replicated[ROW_POLICY] test_replicated_users/test.py::test_create_replicated[SETTINGS_PROFILE] [gw1] [ 28%] PASSED test_quota/test.py::test_consumption_of_show_clusters test_quota/test.py::test_consumption_of_show_databases [gw0] [ 29%] PASSED test_replicated_users/test.py::test_create_replicated[SETTINGS_PROFILE] test_replicated_users/test.py::test_create_replicated[USER] [gw8] [ 30%] PASSED test_s3_with_https/test.py::test_s3_with_https[s3_secure] test_s3_with_https/test.py::test_s3_with_https[s3_secure_with_proxy] [gw1] [ 31%] PASSED test_quota/test.py::test_consumption_of_show_databases test_quota/test.py::test_consumption_of_show_privileges [gw0] [ 32%] PASSED test_replicated_users/test.py::test_create_replicated[USER] test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[QUOTA] [gw8] [ 33%] PASSED test_s3_with_https/test.py::test_s3_with_https[s3_secure_with_proxy] [gw0] [ 34%] PASSED test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[QUOTA] test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[ROLE] [gw1] [ 35%] PASSED test_quota/test.py::test_consumption_of_show_privileges test_quota/test.py::test_consumption_of_show_processlist [gw0] [ 36%] PASSED test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[ROLE] test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[ROW_POLICY] test_replicated_merge_tree_compatibility/test.py::test_replicated_merge_tree_defaults_compatibility [gw0] [ 37%] PASSED test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[ROW_POLICY] test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[SETTINGS_PROFILE] [gw0] [ 38%] PASSED test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[SETTINGS_PROFILE] test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[USER] [gw1] [ 39%] PASSED test_quota/test.py::test_consumption_of_show_processlist test_quota/test.py::test_consumption_of_show_tables [gw5] [ 40%] PASSED test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_create_replicated_merge_tree_with_default_zookeeper test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_create_replicated_merge_tree_with_not_exists_auxiliary_zookeeper [gw0] [ 41%] PASSED test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[USER] test_replicated_users/test.py::test_create_replicated_on_cluster[QUOTA] [gw5] [ 42%] PASSED test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_create_replicated_merge_tree_with_not_exists_auxiliary_zookeeper test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_drop_replicated_merge_tree_with_auxiliary_zookeeper [gw0] [ 43%] PASSED test_replicated_users/test.py::test_create_replicated_on_cluster[QUOTA] test_replicated_users/test.py::test_create_replicated_on_cluster[ROLE] [gw1] [ 44%] PASSED test_quota/test.py::test_consumption_of_show_tables test_quota/test.py::test_dcl_introspection [gw0] [ 45%] PASSED test_replicated_users/test.py::test_create_replicated_on_cluster[ROLE] test_replicated_users/test.py::test_create_replicated_on_cluster[ROW_POLICY] [gw3] [ 46%] FAILED test_postgresql_replica_database_engine_1/test.py::test_restart_server_while_replication_startup_not_finished [gw0] [ 47%] PASSED test_replicated_users/test.py::test_create_replicated_on_cluster[ROW_POLICY] test_replicated_users/test.py::test_create_replicated_on_cluster[SETTINGS_PROFILE] [gw0] [ 48%] PASSED test_replicated_users/test.py::test_create_replicated_on_cluster[SETTINGS_PROFILE] test_replicated_users/test.py::test_create_replicated_on_cluster[USER] test_postgresql_replica_database_engine_1/test.py::test_single_transaction [gw0] [ 49%] PASSED test_replicated_users/test.py::test_create_replicated_on_cluster[USER] test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[QUOTA] [gw0] [ 50%] PASSED test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[QUOTA] test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[ROLE] [gw0] [ 51%] PASSED test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[ROLE] test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[ROW_POLICY] [gw1] [ 52%] PASSED test_quota/test.py::test_dcl_introspection test_quota/test.py::test_dcl_management [gw5] [ 53%] PASSED test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_drop_replicated_merge_tree_with_auxiliary_zookeeper test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_path_ambiguity [gw0] [ 54%] PASSED test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[ROW_POLICY] test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[SETTINGS_PROFILE] [gw0] [ 55%] PASSED test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[SETTINGS_PROFILE] test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[USER] [gw5] [ 56%] PASSED test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_path_ambiguity [gw3] [ 57%] FAILED test_postgresql_replica_database_engine_1/test.py::test_single_transaction [gw0] [ 58%] PASSED test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[USER] test_replicated_users/test.py::test_grant_revoke_replicated[With_ignored_on_cluster] test_postgresql_replica_database_engine_1/test.py::test_table_schema_changes [gw0] [ 59%] PASSED test_replicated_users/test.py::test_grant_revoke_replicated[With_ignored_on_cluster] test_replicated_users/test.py::test_grant_revoke_replicated[Without_on_cluster] [gw1] [ 60%] PASSED test_quota/test.py::test_dcl_management test_quota/test.py::test_exceed_quota [gw0] [ 61%] PASSED test_replicated_users/test.py::test_grant_revoke_replicated[Without_on_cluster] test_replicated_users/test.py::test_reload_zookeeper [gw7] [ 62%] PASSED test_replication_credentials/test.py::test_credentials_and_no_credentials test_replication_credentials/test.py::test_different_credentials [gw3] [ 63%] FAILED test_postgresql_replica_database_engine_1/test.py::test_table_schema_changes test_s3_zero_copy_ttl/test.py::test_ttl_move_and_s3 test_postgresql_replica_database_engine_1/test.py::test_user_managed_slots [gw1] [ 64%] PASSED test_quota/test.py::test_exceed_quota test_quota/test.py::test_query_inserts [gw3] [ 65%] FAILED test_postgresql_replica_database_engine_1/test.py::test_user_managed_slots test_postgresql_replica_database_engine_1/test.py::test_virtual_columns [gw2] [ 66%] PASSED test_replicated_user_defined_functions/test.py::test_reload_zookeeper test_replicated_user_defined_functions/test.py::test_replication [gw7] [ 67%] PASSED test_replication_credentials/test.py::test_different_credentials test_replication_credentials/test.py::test_no_credentials test_render_log_file_name_templates/test.py::test_check_file_names [gw1] [ 68%] PASSED test_quota/test.py::test_query_inserts test_quota/test.py::test_quota_from_users_xml [gw3] [ 69%] FAILED test_postgresql_replica_database_engine_1/test.py::test_virtual_columns [gw2] [ 70%] PASSED test_replicated_user_defined_functions/test.py::test_replication test_replicated_user_defined_functions/test.py::test_replication_replace_by_another_node_after_creation [gw1] [ 71%] PASSED test_quota/test.py::test_quota_from_users_xml test_quota/test.py::test_reload_users_xml_by_timer [gw7] [ 72%] PASSED test_replication_credentials/test.py::test_no_credentials test_replication_credentials/test.py::test_same_credentials [gw2] [ 73%] PASSED test_replicated_user_defined_functions/test.py::test_replication_replace_by_another_node_after_creation test_replicated_user_defined_functions/test.py::test_server_restart [gw1] [ 74%] PASSED test_quota/test.py::test_reload_users_xml_by_timer test_quota/test.py::test_simpliest_quota [gw7] [ 75%] PASSED test_replication_credentials/test.py::test_same_credentials [gw1] [ 76%] PASSED test_quota/test.py::test_simpliest_quota test_quota/test.py::test_tracking_quota [gw0] [ 77%] PASSED test_replicated_users/test.py::test_reload_zookeeper test_replicated_users/test.py::test_rename_replicated[QUOTA] [gw8] [ 78%] PASSED test_render_log_file_name_templates/test.py::test_check_file_names [gw0] [ 79%] PASSED test_replicated_users/test.py::test_rename_replicated[QUOTA] test_replicated_users/test.py::test_rename_replicated[ROLE] [gw0] [ 80%] PASSED test_replicated_users/test.py::test_rename_replicated[ROLE] test_replicated_users/test.py::test_rename_replicated[ROW_POLICY] [gw1] [ 81%] PASSED test_quota/test.py::test_tracking_quota test_quota/test.py::test_users_xml_is_readonly [gw9] [ 82%] PASSED test_replicated_mutations/test.py::test_mutations test_replicated_mutations/test.py::test_mutations_dont_prevent_merges[nodes0] [gw2] [ 83%] PASSED test_replicated_user_defined_functions/test.py::test_server_restart test_replicated_user_defined_functions/test.py::test_start_without_zookeeper [gw0] [ 84%] PASSED test_replicated_users/test.py::test_rename_replicated[ROW_POLICY] test_replicated_users/test.py::test_rename_replicated[SETTINGS_PROFILE] [gw1] [ 85%] PASSED test_quota/test.py::test_users_xml_is_readonly [gw0] [ 86%] PASSED test_replicated_users/test.py::test_rename_replicated[SETTINGS_PROFILE] test_replicated_users/test.py::test_rename_replicated[USER] [gw0] [ 87%] PASSED test_replicated_users/test.py::test_rename_replicated[USER] test_s3_aws_sdk_has_slightly_unreliable_behaviour/test.py::test_dataloss [gw4] [ 88%] PASSED test_replicated_merge_tree_compatibility/test.py::test_replicated_merge_tree_defaults_compatibility [gw6] [ 89%] PASSED test_replicated_merge_tree_s3_zero_copy/test.py::test_drop_table test_replicated_merge_tree_s3_zero_copy/test.py::test_insert_select_replicated[0-16] [gw6] [ 90%] PASSED test_replicated_merge_tree_s3_zero_copy/test.py::test_insert_select_replicated[0-16] test_replicating_constants/test.py::test_different_versions test_replicated_merge_tree_s3_zero_copy/test.py::test_insert_select_replicated[8192-12] [gw6] [ 91%] PASSED test_replicated_merge_tree_s3_zero_copy/test.py::test_insert_select_replicated[8192-12] test_replicated_merge_tree_s3_zero_copy/test.py::test_s3_check_restore [gw6] [ 92%] PASSED test_replicated_merge_tree_s3_zero_copy/test.py::test_s3_check_restore [gw5] [ 93%] PASSED test_s3_zero_copy_ttl/test.py::test_ttl_move_and_s3 [gw2] [ 94%] PASSED test_replicated_user_defined_functions/test.py::test_start_without_zookeeper [gw4] [ 95%] PASSED test_replicating_constants/test.py::test_different_versions test_s3_imds/test_session_token.py::test_credentials_from_metadata [gw9] [ 96%] PASSED test_replicated_mutations/test.py::test_mutations_dont_prevent_merges[nodes0] test_replicated_mutations/test.py::test_mutations_dont_prevent_merges[nodes1] test_shutdown_wait_unfinished_queries/test.py::test_shutdown_wait_unfinished_queries [gw4] [ 97%] PASSED test_s3_imds/test_session_token.py::test_credentials_from_metadata [gw5] [ 98%] PASSED test_shutdown_wait_unfinished_queries/test.py::test_shutdown_wait_unfinished_queries [gw9] [ 99%] PASSED test_replicated_mutations/test.py::test_mutations_dont_prevent_merges[nodes1] [gw8] [100%] PASSED test_s3_aws_sdk_has_slightly_unreliable_behaviour/test.py::test_dataloss =================================== FAILURES =================================== _____________________________ test_replicating_dml _____________________________ [gw3] linux -- Python 3.10.12 /usr/bin/python3 started_cluster = def test_replicating_dml(started_cluster): NUM_TABLES = 5 for i in range(NUM_TABLES): pg_manager.create_postgres_table(f"postgresql_replica_{i}") instance.query( "INSERT INTO postgres_database.postgresql_replica_{} SELECT number, {} from numbers(50)".format( i, i ) ) pg_manager.create_materialized_db( ip=started_cluster.postgres_ip, port=started_cluster.postgres_port ) for i in range(NUM_TABLES): instance.query( f"INSERT INTO postgres_database.postgresql_replica_{i} SELECT 50 + number, {i} from numbers(1000)" ) > check_several_tables_are_synchronized(instance, NUM_TABLES) test_postgresql_replica_database_engine_1/test.py:100: _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ helpers/postgres_utility.py:419: in check_several_tables_are_synchronized check_tables_are_synchronized( helpers/postgres_utility.py:392: in check_tables_are_synchronized result = instance.query(result_query) helpers/cluster.py:3456: in query return self.client.query( helpers/client.py:36: in wrap return func(self, *args, **kwargs) helpers/client.py:74: in query ).get_answer() _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ self = def get_answer(self): self.process.wait(timeout=DEFAULT_QUERY_TIMEOUT) self.stdout_file.seek(0) self.stderr_file.seek(0) stdout = self.stdout_file.read().decode("utf-8", errors="replace") stderr = self.stderr_file.read().decode("utf-8", errors="replace") if ( self.timer is not None and not self.process_finished_before_timeout and not self.ignore_error ): logging.debug(f"Timed out. Last stdout:{stdout}, stderr:{stderr}") raise QueryTimeoutExceedException("Client timed out!") if ( self.process.returncode != 0 or self.remove_trash_from_stderr(stderr) ) and not self.ignore_error: > raise QueryRuntimeException( "Client failed! Return code: {}, stderr: {}".format( self.process.returncode, stderr ), self.process.returncode, stderr, ) E helpers.client.QueryRuntimeException: Client failed! Return code: 60, stderr: Received exception from server (version 24.3.18): E Code: 60. DB::Exception: Received from 172.16.4.3:9000. DB::Exception: Unknown table expression identifier 'test_database.postgresql_replica_0' in scope SELECT * FROM `test_database.postgresql_replica_0` ORDER BY key ASC. Stack trace: E E 0. ./contrib/llvm-project/libcxx/include/exception:141: Poco::Exception::Exception(String const&, int) @ 0x000000003a50df73 E 1. ./build_docker/./src/Common/Exception.cpp:96: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000001cb3f630 E 2. DB::Exception::Exception(int, FormatStringHelperImpl::type, std::type_identity::type>, String const&, String&&) @ 0x000000000c5b9b76 E 3. ./build_docker/./src/Analyzer/Passes/QueryAnalysisPass.cpp:6971: DB::(anonymous namespace)::QueryAnalyzer::resolveQuery(std::shared_ptr const&, DB::(anonymous namespace)::IdentifierResolveScope&) @ 0x000000002db7d229 E 4. ./build_docker/./src/Analyzer/Passes/QueryAnalysisPass.cpp:0: DB::QueryAnalysisPass::run(std::shared_ptr&, std::shared_ptr) @ 0x000000002db6e577 E 5. ./build_docker/./src/Analyzer/QueryTreePassManager.cpp:0: DB::QueryTreePassManager::run(std::shared_ptr) @ 0x000000002db6562e E 6. ./build_docker/./src/Interpreters/InterpreterSelectQueryAnalyzer.cpp:0: DB::(anonymous namespace)::buildQueryTreeAndRunPasses(std::shared_ptr const&, DB::SelectQueryOptions const&, std::shared_ptr const&, std::shared_ptr const&) @ 0x000000002e5acbd6 E 7. ./build_docker/./src/Interpreters/InterpreterSelectQueryAnalyzer.cpp:160: DB::InterpreterSelectQueryAnalyzer::InterpreterSelectQueryAnalyzer(std::shared_ptr const&, std::shared_ptr const&, DB::SelectQueryOptions const&, std::vector> const&) @ 0x000000002e5a56f4 E 8. ./contrib/llvm-project/libcxx/include/__memory/unique_ptr.h:0: std::__unique_if::__unique_single std::make_unique[abi:v15000]&, std::shared_ptr const&, DB::SelectQueryOptions const&>(std::shared_ptr&, std::shared_ptr const&, DB::SelectQueryOptions const&) @ 0x000000002e5b0821 E 9. ./contrib/llvm-project/libcxx/include/__functional/function.h:0: ? @ 0x000000002e46175d E 10. ./build_docker/./src/Interpreters/executeQuery.cpp:0: DB::executeQueryImpl(char const*, char const*, std::shared_ptr, DB::QueryFlags, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x000000002f1e6e0a E 11. ./build_docker/./src/Interpreters/executeQuery.cpp:1376: DB::executeQuery(String const&, std::shared_ptr, DB::QueryFlags, DB::QueryProcessingStage::Enum) @ 0x000000002f1dde8a E 12. ./contrib/llvm-project/libcxx/include/__memory/shared_ptr.h:612: DB::TCPHandler::runImpl() @ 0x00000000326e9c5d E 13. ./build_docker/./src/Server/TCPHandler.cpp:2341: DB::TCPHandler::run() @ 0x000000003272e6b1 E 14. ./build_docker/./base/poco/Net/src/TCPServerConnection.cpp:57: Poco::Net::TCPServerConnection::start() @ 0x000000003a2162af E 15. ./contrib/llvm-project/libcxx/include/__memory/unique_ptr.h:48: Poco::Net::TCPServerDispatcher::run() @ 0x000000003a216f57 E 16. ./build_docker/./base/poco/Foundation/src/ThreadPool.cpp:0: Poco::PooledThread::run() @ 0x000000003a623f3c E 17. ./base/poco/Foundation/include/Poco/SharedPtr.h:231: Poco::ThreadImpl::runnableEntry(void*) @ 0x000000003a61cf28 E 18. asan_thread_start(void*) @ 0x000000000a7b049b E 19. ? @ 0x00007f45fda16ac3 E 20. ? @ 0x00007f45fdaa8850 E . (UNKNOWN_TABLE) E (query: select * from `test_database.postgresql_replica_0` order by key;) helpers/client.py:239: QueryRuntimeException ---------------------------- Captured stdout setup ----------------------------- Copy common default production configuration from /clickhouse-config. Files: config.xml, users.xml PostgreSQL is available - running test ---------------------------- Captured stderr setup ----------------------------- Command:['docker ps | wc -l'] Stdout:1 No running containers Pruning Docker networks Command:['docker network prune --force'] Command:["sysctl net.ipv4.ip_local_port_range='55000 65535'"] Stdout:net.ipv4.ip_local_port_range = 55000 65535 Running tests in /ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/test.py Cluster start called. is_up=False Docker networks for project roottestpostgresqlreplicadatabaseengine1 are NETWORK ID NAME DRIVER SCOPE Docker containers for project roottestpostgresqlreplicadatabaseengine1 are CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES Docker volumes for project roottestpostgresqlreplicadatabaseengine1 are DRIVER VOLUME NAME Cleanup called Docker networks for project roottestpostgresqlreplicadatabaseengine1 are NETWORK ID NAME DRIVER SCOPE Docker containers for project roottestpostgresqlreplicadatabaseengine1 are CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES Docker volumes for project roottestpostgresqlreplicadatabaseengine1 are DRIVER VOLUME NAME Command:docker container list --all --filter name='^/roottestpostgresqlreplicadatabaseengine1_.*_1$' --format '{{.ID}}:{{.Names}}' Unstopped containers: {} No running containers for project: roottestpostgresqlreplicadatabaseengine1 Trying to prune unused networks... Trying to prune unused images... Command:['docker', 'image', 'prune', '-f'] Stderr:Error response from daemon: a prune operation is already running Exitcode:1 Trying to prune unused volumes... Command:['docker volume ls | wc -l'] Stdout:1 Setup directory for instance: instance Create directory for configuration generated in this helper Create directory for common tests configuration Copy common configuration from helpers Generate and write macros file Copy custom test config files ['/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/configs/log_conf.xml'] to /ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/instance/configs/config.d Setup database dir /ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/instance/database Setup logs dir /ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/instance/logs Entrypoint cmd: bash -c "trap 'pkill tail' INT TERM; clickhouse server --config-file=/etc/clickhouse-server/config.xml --log-file=/var/log/clickhouse-server/clickhouse-server.log --errorlog-file=/var/log/clickhouse-server/clickhouse-server.err.log --daemon; coproc tail -f /dev/null; wait $$!" Env {'ASAN_OPTIONS': 'use_sigaltstack=0', 'TSAN_OPTIONS': 'use_sigaltstack=0', 'CLICKHOUSE_WATCHDOG_ENABLE': '0', 'CLICKHOUSE_NATS_TLS_SECURE': '0', 'LLVM_PROFILE_FILE': '/var/lib/clickhouse/server_%h_%p_%m.profraw', 'POSTGRES_PORT': '5432', 'POSTGRES_DIR': '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/postgres/postgres1', 'POSTGRES_LOGS_FS': 'bind'} stored in /ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/.env Trying paths: ['/root/.docker/config.json', '/root/.dockercfg'] No config file found Trying paths: ['/root/.docker/config.json', '/root/.dockercfg'] No config file found http://localhost:None "GET /version HTTP/1.1" 200 826 Command:['docker-compose', '--env-file', '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/.env', '--project-name', 'roottestpostgresqlreplicadatabaseengine1', '--file', '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/instance/docker-compose.yml', '--file', '/ClickHouse/tests/integration/helpers/../../../tests/integration/compose/docker_compose_postgres.yml', 'pull'] Stderr:Pulling postgres1 ... Stderr:Pulling instance ... Stderr:Pulling instance ... pulling from altinityinfra/integr... Stderr:Pulling instance ... digest: sha256:8a2c68e2d63d82c826... Stderr:Pulling instance ... status: image is up to date for a... Stderr:Pulling instance ... done Stderr:Pulling postgres1 ... pulling from library/postgres Stderr:Pulling postgres1 ... digest: sha256:6efd0df010dc3cb40d... Stderr:Pulling postgres1 ... status: image is up to date for p... Stderr:Pulling postgres1 ... done Setup Postgres Command:['docker-compose', '--env-file', '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/.env', '--project-name', 'roottestpostgresqlreplicadatabaseengine1', '--file', '/ClickHouse/tests/integration/helpers/../../../tests/integration/compose/docker_compose_postgres.yml', '--verbose', 'up', '-d'] Stderr:compose.config.config.find: Using configuration files: /ClickHouse/tests/integration/helpers/../../../tests/integration/compose/docker_compose_postgres.yml Stderr:compose.cli.docker_client.get_client: docker-compose version 1.29.2, build unknown Stderr:docker-py version: Stderr:CPython version: 3.10.12 Stderr:OpenSSL version: OpenSSL 3.0.2 15 Mar 2022 Stderr:compose.cli.docker_client.get_client: Docker base_url: http+docker://localhost Stderr:compose.cli.docker_client.get_client: Docker version: Platform={'Name': 'Docker Engine - Community'}, Components=[{'Name': 'Engine', 'Version': '23.0.6', 'Details': {'ApiVersion': '1.42', 'Arch': 'amd64', 'BuildTime': '2023-05-05T21:18:13.000000000+00:00', 'Experimental': 'false', 'GitCommit': '9dbdbd4', 'GoVersion': 'go1.19.9', 'KernelVersion': '5.15.0-130-generic', 'MinAPIVersion': '1.12', 'Os': 'linux'}}, {'Name': 'containerd', 'Version': '1.7.18', 'Details': {'GitCommit': 'ae71819c4f5e67bb4d5ae76a6b735f29cc25774e'}}, {'Name': 'runc', 'Version': '1.7.18', 'Details': {'GitCommit': 'v1.1.13-0-g58aa920'}}, {'Name': 'docker-init', 'Version': '0.19.0', 'Details': {'GitCommit': 'de40ad0'}}], Version=23.0.6, ApiVersion=1.42, MinAPIVersion=1.12, GitCommit=9dbdbd4, GoVersion=go1.19.9, Os=linux, Arch=amd64, KernelVersion=5.15.0-130-generic, BuildTime=2023-05-05T21:18:13.000000000+00:00 Stderr:compose.cli.verbose_proxy.proxy_callable: docker inspect_network <- ('roottestpostgresqlreplicadatabaseengine1_default') Stderr:compose.cli.verbose_proxy.proxy_callable: docker info <- () Stderr:compose.cli.verbose_proxy.proxy_callable: docker info -> {'Architecture': 'x86_64', Stderr: 'BridgeNfIp6tables': True, Stderr: 'BridgeNfIptables': True, Stderr: 'CPUSet': True, Stderr: 'CPUShares': True, Stderr: 'CgroupDriver': 'cgroupfs', Stderr: 'CgroupVersion': '2', Stderr: 'ContainerdCommit': {'Expected': 'ae71819c4f5e67bb4d5ae76a6b735f29cc25774e', Stderr: 'ID': 'ae71819c4f5e67bb4d5ae76a6b735f29cc25774e'}, Stderr: 'Containers': 2, Stderr:... Stderr:compose.cli.verbose_proxy.proxy_callable: docker inspect_network <- ('roottestpostgresqlreplicadatabaseengine1_default') Stderr:compose.network.ensure: Creating network "roottestpostgresqlreplicadatabaseengine1_default" with the default driver Stderr:compose.cli.verbose_proxy.proxy_callable: docker create_network <- (name='roottestpostgresqlreplicadatabaseengine1_default', driver=None, options=None, ipam=None, internal=False, enable_ipv6=False, labels={'com.docker.compose.project': 'roottestpostgresqlreplicadatabaseengine1', 'com.docker.compose.network': 'default', 'com.docker.compose.version': '1.29.2'}, attachable=True, check_duplicate=True) Stderr:compose.cli.verbose_proxy.proxy_callable: docker create_network -> {'Id': 'abd722f92060adf278fe7f8a7ee3b0b1950c913c3c138377f848edf41ffc7631', Stderr: 'Warning': ''} Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers <- (all=False, filters={'label': ['com.docker.compose.project=roottestpostgresqlreplicadatabaseengine1', 'com.docker.compose.oneoff=False']}) Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers -> (list with 0 items) Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers <- (all=False, filters={'label': ['com.docker.compose.project=roottestpostgresqlreplicadatabaseengine1', 'com.docker.compose.oneoff=False']}) Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers -> (list with 0 items) Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers <- (all=True, filters={'label': ['com.docker.compose.project=roottestpostgresqlreplicadatabaseengine1', 'com.docker.compose.oneoff=False']}) Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers -> (list with 0 items) Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers <- (all=True, filters={'label': ['com.docker.compose.project=roottestpostgresqlreplicadatabaseengine1', 'com.docker.compose.oneoff=False']}) Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers -> (list with 0 items) Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers <- (all=True, filters={'label': ['com.docker.compose.project=roottestpostgresqlreplicadatabaseengine1', 'com.docker.compose.service=postgres1', 'com.docker.compose.oneoff=False']}) Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers -> (list with 0 items) Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers <- (all=True, filters={'label': ['com.docker.compose.project=roottestpostgresqlreplicadatabaseengine1', 'com.docker.compose.service=postgres1', 'com.docker.compose.oneoff=False']}) Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers -> (list with 0 items) Stderr:compose.cli.verbose_proxy.proxy_callable: docker inspect_image <- ('postgres') Stderr:compose.cli.verbose_proxy.proxy_callable: docker inspect_image -> {'Architecture': 'amd64', Stderr: 'Author': '', Stderr: 'Comment': 'buildkit.dockerfile.v0', Stderr: 'Config': {'AttachStderr': False, Stderr: 'AttachStdin': False, Stderr: 'AttachStdout': False, Stderr: 'Cmd': ['postgres'], Stderr: 'Domainname': '', Stderr: 'Entrypoint': ['docker-entrypoint.sh'], Stderr: 'Env': ['PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/lib/postgresql/17/bin', Stderr:... Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers <- (all=True, filters={'label': ['com.docker.compose.project=roottestpostgresqlreplicadatabaseengine1', 'com.docker.compose.service=postgres1', 'com.docker.compose.oneoff=False']}) Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers -> (list with 0 items) Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers <- (all=True, filters={'label': ['com.docker.compose.project=roottestpostgresqlreplicadatabaseengine1', 'com.docker.compose.service=postgres1', 'com.docker.compose.oneoff=False']}) Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers -> (list with 0 items) Stderr:compose.parallel.feed_queue: Pending: {} Stderr:compose.parallel.feed_queue: Starting producer thread for Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers <- (all=True, filters={'label': ['com.docker.compose.project=roottestpostgresqlreplicadatabaseengine1', 'com.docker.compose.service=postgres1', 'com.docker.compose.oneoff=False']}) Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers -> (list with 0 items) Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers <- (all=True, filters={'label': ['com.docker.compose.project=roottestpostgresqlreplicadatabaseengine1', 'com.docker.compose.service=postgres1', 'com.docker.compose.oneoff=False']}) Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers -> (list with 0 items) Stderr:Creating roottestpostgresqlreplicadatabaseengine1_postgres1_1 ... Stderr:compose.parallel.feed_queue: Pending: {ServiceName(project='roottestpostgresqlreplicadatabaseengine1', service='postgres1', number=1)} Stderr:compose.parallel.feed_queue: Starting producer thread for ServiceName(project='roottestpostgresqlreplicadatabaseengine1', service='postgres1', number=1) Stderr:compose.cli.verbose_proxy.proxy_callable: docker inspect_image <- ('postgres') Stderr:compose.cli.verbose_proxy.proxy_callable: docker inspect_image -> {'Architecture': 'amd64', Stderr: 'Author': '', Stderr: 'Comment': 'buildkit.dockerfile.v0', Stderr: 'Config': {'AttachStderr': False, Stderr: 'AttachStdin': False, Stderr: 'AttachStdout': False, Stderr: 'Cmd': ['postgres'], Stderr: 'Domainname': '', Stderr: 'Entrypoint': ['docker-entrypoint.sh'], Stderr: 'Env': ['PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/lib/postgresql/17/bin', Stderr:... Stderr:compose.cli.verbose_proxy.proxy_callable: docker inspect_image <- ('postgres') Stderr:compose.cli.verbose_proxy.proxy_callable: docker inspect_image -> {'Architecture': 'amd64', Stderr: 'Author': '', Stderr: 'Comment': 'buildkit.dockerfile.v0', Stderr: 'Config': {'AttachStderr': False, Stderr: 'AttachStdin': False, Stderr: 'AttachStdout': False, Stderr: 'Cmd': ['postgres'], Stderr: 'Domainname': '', Stderr: 'Entrypoint': ['docker-entrypoint.sh'], Stderr: 'Env': ['PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/lib/postgresql/17/bin', Stderr:... Stderr:compose.service.build_container_labels: Added config hash: 93968ec629d91980ea64eb0c7d74531b9606057f28d2f63fd9c8a6b21e104bb1 Stderr:compose.cli.verbose_proxy.proxy_callable: docker create_host_config <- (links=[], port_bindings={}, binds=[], volumes_from=[], privileged=False, network_mode='roottestpostgresqlreplicadatabaseengine1_default', devices=None, device_requests=None, dns=None, dns_opt=None, dns_search=None, restart_policy={'Name': 'always', 'MaximumRetryCount': 0}, runtime=None, cap_add=None, cap_drop=None, mem_limit=None, mem_reservation=None, memswap_limit=None, ulimits=None, log_config={'Type': '', 'Config': {}}, extra_hosts=None, read_only=None, pid_mode=None, security_opt=None, ipc_mode=None, cgroup_parent=None, cpu_quota=None, shm_size=None, sysctls=None, pids_limit=None, tmpfs=None, oom_kill_disable=None, oom_score_adj=None, mem_swappiness=None, group_add=None, userns_mode=None, init=None, init_path=None, isolation=None, cpu_count=None, cpu_percent=None, nano_cpus=None, volume_driver=None, cpuset_cpus=None, cpu_shares=None, storage_opt=None, blkio_weight=None, blkio_weight_device=None, device_read_bps=None, device_read_iops=None, device_write_bps=None, device_write_iops=None, mounts=[{'Target': '/postgres/', 'Source': '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/postgres/postgres1', 'Type': 'bind', 'ReadOnly': None}], device_cgroup_rules=None, cpu_period=None, cpu_rt_period=None, cpu_rt_runtime=None) Stderr:compose.cli.verbose_proxy.proxy_callable: docker create_host_config -> {'Binds': [], Stderr: 'Links': [], Stderr: 'LogConfig': {'Config': {}, 'Type': ''}, Stderr: 'Mounts': [{'ReadOnly': None, Stderr: 'Source': '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/postgres/postgres1', Stderr: 'Target': '/postgres/', Stderr: 'Type': 'bind'}], Stderr: 'NetworkMode': 'roottestpostgresqlreplicadatabaseengine1_default', Stderr: 'PortBindings': {}, Stderr: 'RestartPolicy': {'MaximumRetryCount': 0, 'Name': 'always'}, Stderr:... Stderr:compose.cli.verbose_proxy.proxy_callable: docker create_container <- (command=['postgres', '-c', 'wal_level=logical', '-c', 'max_replication_slots=4', '-c', 'logging_collector=on', '-c', 'log_directory=/postgres/logs', '-c', 'log_filename=postgresql.log', '-c', 'log_statement=all', '-c', 'max_connections=200'], environment=['POSTGRES_HOST_AUTH_METHOD=trust', 'POSTGRES_PASSWORD=mysecretpassword', 'PGDATA=/postgres/data'], healthcheck={'test': ['CMD-SHELL', 'pg_isready -U postgres'], 'interval': 10000000000, 'timeout': 5000000000, 'retries': 5}, image='postgres', volumes={}, name='roottestpostgresqlreplicadatabaseengine1_postgres1_1', detach=True, ports=['5432'], labels={'com.docker.compose.project': 'roottestpostgresqlreplicadatabaseengine1', 'com.docker.compose.service': 'postgres1', 'com.docker.compose.oneoff': 'False', 'com.docker.compose.project.working_dir': '/ClickHouse/tests/integration/compose', 'com.docker.compose.project.config_files': '/ClickHouse/tests/integration/compose/docker_compose_postgres.yml', 'com.docker.compose.project.environment_file': '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/.env', 'com.docker.compose.container-number': '1', 'com.docker.compose.version': '1.29.2', 'com.docker.compose.config-hash': '93968ec629d91980ea64eb0c7d74531b9606057f28d2f63fd9c8a6b21e104bb1'}, host_config={'NetworkMode': 'roottestpostgresqlreplicadatabaseengine1_default', 'RestartPolicy': {'Name': 'always', 'MaximumRetryCount': 0}, 'VolumesFrom': [], 'Binds': [], 'PortBindings': {}, 'Links': [], 'LogConfig': {'Type': '', 'Config': {}}, 'Mounts': [{'Target': '/postgres/', 'Source': '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/postgres/postgres1', 'Type': 'bind', 'ReadOnly': None}]}, networking_config={'EndpointsConfig': {'roottestpostgresqlreplicadatabaseengine1_default': {'Aliases': ['postgres1', 'postgre-sql.local'], 'IPAMConfig': {}}}}) Stderr:compose.cli.verbose_proxy.proxy_callable: docker create_container -> {'Id': '2f626e093c8aebac93ce63dedbe78597a8d44fd075ee1d2e09405b492caac01a', Stderr: 'Warnings': []} Stderr:compose.cli.verbose_proxy.proxy_callable: docker inspect_container <- ('2f626e093c8aebac93ce63dedbe78597a8d44fd075ee1d2e09405b492caac01a') Stderr:compose.cli.verbose_proxy.proxy_callable: docker inspect_container -> {'AppArmorProfile': '', Stderr: 'Args': ['postgres', Stderr: '-c', Stderr: 'wal_level=logical', Stderr: '-c', Stderr: 'max_replication_slots=4', Stderr: '-c', Stderr: 'logging_collector=on', Stderr: '-c', Stderr: 'log_directory=/postgres/logs', Stderr:... Stderr:compose.cli.verbose_proxy.proxy_callable: docker disconnect_container_from_network <- ('2f626e093c8aebac93ce63dedbe78597a8d44fd075ee1d2e09405b492caac01a', 'roottestpostgresqlreplicadatabaseengine1_default') Stderr:compose.cli.verbose_proxy.proxy_callable: docker disconnect_container_from_network -> None Stderr:compose.cli.verbose_proxy.proxy_callable: docker connect_container_to_network <- ('2f626e093c8aebac93ce63dedbe78597a8d44fd075ee1d2e09405b492caac01a', 'roottestpostgresqlreplicadatabaseengine1_default', aliases=['postgres1', 'postgre-sql.local', '2f626e093c8a'], ipv4_address=None, ipv6_address=None, links=[], link_local_ips=None) Stderr:compose.cli.verbose_proxy.proxy_callable: docker connect_container_to_network -> None Stderr:compose.cli.verbose_proxy.proxy_callable: docker start <- ('2f626e093c8aebac93ce63dedbe78597a8d44fd075ee1d2e09405b492caac01a') Stderr:compose.parallel.feed_queue: Pending: set() Stderr:compose.parallel.feed_queue: Pending: set() Stderr:compose.parallel.feed_queue: Pending: set() Stderr:compose.parallel.feed_queue: Pending: set() Stderr:compose.parallel.feed_queue: Pending: set() Stderr:compose.parallel.feed_queue: Pending: set() Stderr:compose.parallel.feed_queue: Pending: set() Stderr:compose.parallel.feed_queue: Pending: set() Stderr:compose.parallel.feed_queue: Pending: set() Stderr:compose.parallel.feed_queue: Pending: set() Stderr:compose.parallel.feed_queue: Pending: set() Stderr:compose.parallel.feed_queue: Pending: set() Stderr:compose.parallel.feed_queue: Pending: set() Stderr:compose.parallel.feed_queue: Pending: set() Stderr:compose.parallel.feed_queue: Pending: set() Stderr:compose.parallel.feed_queue: Pending: set() Stderr:compose.cli.verbose_proxy.proxy_callable: docker start -> None Stderr:compose.parallel.parallel_execute_iter: Finished processing: ServiceName(project='roottestpostgresqlreplicadatabaseengine1', service='postgres1', number=1) Stderr:Creating roottestpostgresqlreplicadatabaseengine1_postgres1_1 ... done Stderr:compose.parallel.feed_queue: Pending: set() Stderr:compose.parallel.parallel_execute_iter: Finished processing: Stderr:compose.parallel.feed_queue: Pending: set() get_instance_ip instance_name=postgres1 http://localhost:None "GET /v1.42/containers/roottestpostgresqlreplicadatabaseengine1_postgres1_1/json HTTP/1.1" 200 None Can't connect to Postgres connection to server at "172.16.4.2", port 5432 failed: Connection refused Is the server running on that host and accepting TCP/IP connections? Can't connect to Postgres connection to server at "172.16.4.2", port 5432 failed: Connection refused Is the server running on that host and accepting TCP/IP connections? Can't connect to Postgres connection to server at "172.16.4.2", port 5432 failed: Connection refused Is the server running on that host and accepting TCP/IP connections? Postgres Started ('Trying to create ClickHouse instance by command %s', 'docker-compose --env-file /ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/.env --project-name roottestpostgresqlreplicadatabaseengine1 --file /ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/instance/docker-compose.yml --file /ClickHouse/tests/integration/helpers/../../../tests/integration/compose/docker_compose_postgres.yml up -d --no-recreate') Command:['docker-compose', '--env-file', '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/.env', '--project-name', 'roottestpostgresqlreplicadatabaseengine1', '--file', '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/instance/docker-compose.yml', '--file', '/ClickHouse/tests/integration/helpers/../../../tests/integration/compose/docker_compose_postgres.yml', 'up', '-d', '--no-recreate'] Stderr:Creating roottestpostgresqlreplicadatabaseengine1_instance_1 ... Stderr:Creating roottestpostgresqlreplicadatabaseengine1_instance_1 ... done ClickHouse instance created get_instance_ip instance_name=instance http://localhost:None "GET /v1.42/containers/roottestpostgresqlreplicadatabaseengine1_instance_1/json HTTP/1.1" 200 None Waiting for ClickHouse start in instance, ip: 172.16.4.3... http://localhost:None "GET /v1.42/containers/roottestpostgresqlreplicadatabaseengine1_instance_1/json HTTP/1.1" 200 None http://localhost:None "GET /v1.42/containers/0d1c06220f0e0b9b7f75b10eb8cf0da3620284b4fe6c60091cdceae27ff52095/json HTTP/1.1" 200 None http://localhost:None "GET /v1.42/containers/0d1c06220f0e0b9b7f75b10eb8cf0da3620284b4fe6c60091cdceae27ff52095/json HTTP/1.1" 200 None http://localhost:None "GET /v1.42/containers/0d1c06220f0e0b9b7f75b10eb8cf0da3620284b4fe6c60091cdceae27ff52095/json HTTP/1.1" 200 None http://localhost:None "GET /v1.42/containers/0d1c06220f0e0b9b7f75b10eb8cf0da3620284b4fe6c60091cdceae27ff52095/json HTTP/1.1" 200 None http://localhost:None "GET /v1.42/containers/0d1c06220f0e0b9b7f75b10eb8cf0da3620284b4fe6c60091cdceae27ff52095/json HTTP/1.1" 200 None http://localhost:None "GET /v1.42/containers/0d1c06220f0e0b9b7f75b10eb8cf0da3620284b4fe6c60091cdceae27ff52095/json HTTP/1.1" 200 None http://localhost:None "GET /v1.42/containers/0d1c06220f0e0b9b7f75b10eb8cf0da3620284b4fe6c60091cdceae27ff52095/json HTTP/1.1" 200 None http://localhost:None "GET /v1.42/containers/0d1c06220f0e0b9b7f75b10eb8cf0da3620284b4fe6c60091cdceae27ff52095/json HTTP/1.1" 200 None http://localhost:None "GET /v1.42/containers/0d1c06220f0e0b9b7f75b10eb8cf0da3620284b4fe6c60091cdceae27ff52095/json HTTP/1.1" 200 None http://localhost:None "GET /v1.42/containers/0d1c06220f0e0b9b7f75b10eb8cf0da3620284b4fe6c60091cdceae27ff52095/json HTTP/1.1" 200 None http://localhost:None "GET /v1.42/containers/0d1c06220f0e0b9b7f75b10eb8cf0da3620284b4fe6c60091cdceae27ff52095/json HTTP/1.1" 200 None http://localhost:None "GET /v1.42/containers/0d1c06220f0e0b9b7f75b10eb8cf0da3620284b4fe6c60091cdceae27ff52095/json HTTP/1.1" 200 None http://localhost:None "GET /v1.42/containers/0d1c06220f0e0b9b7f75b10eb8cf0da3620284b4fe6c60091cdceae27ff52095/json HTTP/1.1" 200 None http://localhost:None "GET /v1.42/containers/0d1c06220f0e0b9b7f75b10eb8cf0da3620284b4fe6c60091cdceae27ff52095/json HTTP/1.1" 200 None http://localhost:None "GET /v1.42/containers/0d1c06220f0e0b9b7f75b10eb8cf0da3620284b4fe6c60091cdceae27ff52095/json HTTP/1.1" 200 None http://localhost:None "GET /v1.42/containers/0d1c06220f0e0b9b7f75b10eb8cf0da3620284b4fe6c60091cdceae27ff52095/json HTTP/1.1" 200 None http://localhost:None "GET /v1.42/containers/0d1c06220f0e0b9b7f75b10eb8cf0da3620284b4fe6c60091cdceae27ff52095/json HTTP/1.1" 200 None http://localhost:None "GET /v1.42/containers/0d1c06220f0e0b9b7f75b10eb8cf0da3620284b4fe6c60091cdceae27ff52095/json HTTP/1.1" 200 None http://localhost:None "GET /v1.42/containers/0d1c06220f0e0b9b7f75b10eb8cf0da3620284b4fe6c60091cdceae27ff52095/json HTTP/1.1" 200 None http://localhost:None "GET /v1.42/containers/0d1c06220f0e0b9b7f75b10eb8cf0da3620284b4fe6c60091cdceae27ff52095/json HTTP/1.1" 200 None http://localhost:None "GET /v1.42/containers/0d1c06220f0e0b9b7f75b10eb8cf0da3620284b4fe6c60091cdceae27ff52095/json HTTP/1.1" 200 None http://localhost:None "GET /v1.42/containers/0d1c06220f0e0b9b7f75b10eb8cf0da3620284b4fe6c60091cdceae27ff52095/json HTTP/1.1" 200 None http://localhost:None "GET /v1.42/containers/0d1c06220f0e0b9b7f75b10eb8cf0da3620284b4fe6c60091cdceae27ff52095/json HTTP/1.1" 200 None ClickHouse instance started Executing query DROP DATABASE IF EXISTS "postgres_database" on instance Executing query CREATE DATABASE "postgres_database" ENGINE = PostgreSQL('172.16.4.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') on instance ------------------------------ Captured log setup ------------------------------ 2025-06-04 01:15:50 [ 520 ] DEBUG : Command:['docker ps | wc -l'] (cluster.py:113, run_and_check) 2025-06-04 01:15:50 [ 520 ] DEBUG : Stdout:1 (cluster.py:121, run_and_check) 2025-06-04 01:15:50 [ 520 ] DEBUG : No running containers (conftest.py:92, cleanup_environment) 2025-06-04 01:15:50 [ 520 ] DEBUG : Pruning Docker networks (conftest.py:94, cleanup_environment) 2025-06-04 01:15:50 [ 520 ] DEBUG : Command:['docker network prune --force'] (cluster.py:113, run_and_check) 2025-06-04 01:15:50 [ 520 ] DEBUG : Command:["sysctl net.ipv4.ip_local_port_range='55000 65535'"] (cluster.py:113, run_and_check) 2025-06-04 01:15:50 [ 520 ] DEBUG : Stdout:net.ipv4.ip_local_port_range = 55000 65535 (cluster.py:121, run_and_check) 2025-06-04 01:15:50 [ 520 ] INFO : Running tests in /ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/test.py (cluster.py:2659, start) 2025-06-04 01:15:50 [ 520 ] DEBUG : Cluster start called. is_up=False (cluster.py:2666, start) 2025-06-04 01:15:50 [ 520 ] DEBUG : Docker networks for project roottestpostgresqlreplicadatabaseengine1 are NETWORK ID NAME DRIVER SCOPE (cluster.py:780, print_all_docker_pieces) 2025-06-04 01:15:50 [ 520 ] DEBUG : Docker containers for project roottestpostgresqlreplicadatabaseengine1 are CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES (cluster.py:788, print_all_docker_pieces) 2025-06-04 01:15:50 [ 520 ] DEBUG : Docker volumes for project roottestpostgresqlreplicadatabaseengine1 are DRIVER VOLUME NAME (cluster.py:796, print_all_docker_pieces) 2025-06-04 01:15:50 [ 520 ] DEBUG : Cleanup called (cluster.py:801, cleanup) 2025-06-04 01:15:50 [ 520 ] DEBUG : Docker networks for project roottestpostgresqlreplicadatabaseengine1 are NETWORK ID NAME DRIVER SCOPE (cluster.py:780, print_all_docker_pieces) 2025-06-04 01:15:50 [ 520 ] DEBUG : Docker containers for project roottestpostgresqlreplicadatabaseengine1 are CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES (cluster.py:788, print_all_docker_pieces) 2025-06-04 01:15:50 [ 520 ] DEBUG : Docker volumes for project roottestpostgresqlreplicadatabaseengine1 are DRIVER VOLUME NAME (cluster.py:796, print_all_docker_pieces) 2025-06-04 01:15:50 [ 520 ] DEBUG : Command:docker container list --all --filter name='^/roottestpostgresqlreplicadatabaseengine1_.*_1$' --format '{{.ID}}:{{.Names}}' (cluster.py:113, run_and_check) 2025-06-04 01:15:50 [ 520 ] DEBUG : Unstopped containers: {} (cluster.py:815, cleanup) 2025-06-04 01:15:50 [ 520 ] DEBUG : No running containers for project: roottestpostgresqlreplicadatabaseengine1 (cluster.py:829, cleanup) 2025-06-04 01:15:50 [ 520 ] DEBUG : Trying to prune unused networks... (cluster.py:835, cleanup) 2025-06-04 01:15:50 [ 520 ] DEBUG : Trying to prune unused images... (cluster.py:851, cleanup) 2025-06-04 01:15:50 [ 520 ] DEBUG : Command:['docker', 'image', 'prune', '-f'] (cluster.py:113, run_and_check) 2025-06-04 01:15:50 [ 520 ] DEBUG : Stderr:Error response from daemon: a prune operation is already running (cluster.py:123, run_and_check) 2025-06-04 01:15:50 [ 520 ] DEBUG : Exitcode:1 (cluster.py:125, run_and_check) 2025-06-04 01:15:50 [ 520 ] DEBUG : Trying to prune unused volumes... (cluster.py:860, cleanup) 2025-06-04 01:15:50 [ 520 ] DEBUG : Command:['docker volume ls | wc -l'] (cluster.py:113, run_and_check) 2025-06-04 01:15:50 [ 520 ] DEBUG : Stdout:1 (cluster.py:121, run_and_check) 2025-06-04 01:15:50 [ 520 ] DEBUG : Setup directory for instance: instance (cluster.py:2679, start) 2025-06-04 01:15:50 [ 520 ] DEBUG : Create directory for configuration generated in this helper (cluster.py:4383, create_dir) 2025-06-04 01:15:50 [ 520 ] DEBUG : Create directory for common tests configuration (cluster.py:4388, create_dir) 2025-06-04 01:15:50 [ 520 ] DEBUG : Copy common configuration from helpers (cluster.py:4408, create_dir) 2025-06-04 01:15:50 [ 520 ] DEBUG : Generate and write macros file (cluster.py:4441, create_dir) 2025-06-04 01:15:50 [ 520 ] DEBUG : Copy custom test config files ['/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/configs/log_conf.xml'] to /ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/instance/configs/config.d (cluster.py:4471, create_dir) 2025-06-04 01:15:50 [ 520 ] DEBUG : Setup database dir /ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/instance/database (cluster.py:4488, create_dir) 2025-06-04 01:15:50 [ 520 ] DEBUG : Setup logs dir /ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/instance/logs (cluster.py:4499, create_dir) 2025-06-04 01:15:50 [ 520 ] DEBUG : Entrypoint cmd: bash -c "trap 'pkill tail' INT TERM; clickhouse server --config-file=/etc/clickhouse-server/config.xml --log-file=/var/log/clickhouse-server/clickhouse-server.log --errorlog-file=/var/log/clickhouse-server/clickhouse-server.err.log --daemon; coproc tail -f /dev/null; wait $$!" (cluster.py:4582, create_dir) 2025-06-04 01:15:50 [ 520 ] DEBUG : Env {'ASAN_OPTIONS': 'use_sigaltstack=0', 'TSAN_OPTIONS': 'use_sigaltstack=0', 'CLICKHOUSE_WATCHDOG_ENABLE': '0', 'CLICKHOUSE_NATS_TLS_SECURE': '0', 'LLVM_PROFILE_FILE': '/var/lib/clickhouse/server_%h_%p_%m.profraw', 'POSTGRES_PORT': '5432', 'POSTGRES_DIR': '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/postgres/postgres1', 'POSTGRES_LOGS_FS': 'bind'} stored in /ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/.env (cluster.py:86, _create_env_file) 2025-06-04 01:15:50 [ 520 ] DEBUG : Trying paths: ['/root/.docker/config.json', '/root/.dockercfg'] (config.py:21, find_config_file) 2025-06-04 01:15:50 [ 520 ] DEBUG : No config file found (config.py:28, find_config_file) 2025-06-04 01:15:50 [ 520 ] DEBUG : Trying paths: ['/root/.docker/config.json', '/root/.dockercfg'] (config.py:21, find_config_file) 2025-06-04 01:15:50 [ 520 ] DEBUG : No config file found (config.py:28, find_config_file) 2025-06-04 01:15:50 [ 520 ] DEBUG : http://localhost:None "GET /version HTTP/1.1" 200 826 (connectionpool.py:546, _make_request) 2025-06-04 01:15:50 [ 520 ] DEBUG : Command:['docker-compose', '--env-file', '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/.env', '--project-name', 'roottestpostgresqlreplicadatabaseengine1', '--file', '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/instance/docker-compose.yml', '--file', '/ClickHouse/tests/integration/helpers/../../../tests/integration/compose/docker_compose_postgres.yml', 'pull'] (cluster.py:113, run_and_check) 2025-06-04 01:16:01 [ 520 ] DEBUG : Stderr:Pulling postgres1 ... (cluster.py:123, run_and_check) 2025-06-04 01:16:01 [ 520 ] DEBUG : Stderr:Pulling instance ... (cluster.py:123, run_and_check) 2025-06-04 01:16:01 [ 520 ] DEBUG : Stderr:Pulling instance ... pulling from altinityinfra/integr... (cluster.py:123, run_and_check) 2025-06-04 01:16:01 [ 520 ] DEBUG : Stderr:Pulling instance ... digest: sha256:8a2c68e2d63d82c826... (cluster.py:123, run_and_check) 2025-06-04 01:16:01 [ 520 ] DEBUG : Stderr:Pulling instance ... status: image is up to date for a... (cluster.py:123, run_and_check) 2025-06-04 01:16:01 [ 520 ] DEBUG : Stderr:Pulling instance ... done (cluster.py:123, run_and_check) 2025-06-04 01:16:01 [ 520 ] DEBUG : Stderr:Pulling postgres1 ... pulling from library/postgres (cluster.py:123, run_and_check) 2025-06-04 01:16:01 [ 520 ] DEBUG : Stderr:Pulling postgres1 ... digest: sha256:6efd0df010dc3cb40d... (cluster.py:123, run_and_check) 2025-06-04 01:16:01 [ 520 ] DEBUG : Stderr:Pulling postgres1 ... status: image is up to date for p... (cluster.py:123, run_and_check) 2025-06-04 01:16:01 [ 520 ] DEBUG : Stderr:Pulling postgres1 ... done (cluster.py:123, run_and_check) 2025-06-04 01:16:01 [ 520 ] DEBUG : Setup Postgres (cluster.py:2791, start) 2025-06-04 01:16:01 [ 520 ] DEBUG : Command:['docker-compose', '--env-file', '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/.env', '--project-name', 'roottestpostgresqlreplicadatabaseengine1', '--file', '/ClickHouse/tests/integration/helpers/../../../tests/integration/compose/docker_compose_postgres.yml', '--verbose', 'up', '-d'] (cluster.py:113, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr:compose.config.config.find: Using configuration files: /ClickHouse/tests/integration/helpers/../../../tests/integration/compose/docker_compose_postgres.yml (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr:compose.cli.docker_client.get_client: docker-compose version 1.29.2, build unknown (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr:docker-py version: (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr:CPython version: 3.10.12 (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr:OpenSSL version: OpenSSL 3.0.2 15 Mar 2022 (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr:compose.cli.docker_client.get_client: Docker base_url: http+docker://localhost (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr:compose.cli.docker_client.get_client: Docker version: Platform={'Name': 'Docker Engine - Community'}, Components=[{'Name': 'Engine', 'Version': '23.0.6', 'Details': {'ApiVersion': '1.42', 'Arch': 'amd64', 'BuildTime': '2023-05-05T21:18:13.000000000+00:00', 'Experimental': 'false', 'GitCommit': '9dbdbd4', 'GoVersion': 'go1.19.9', 'KernelVersion': '5.15.0-130-generic', 'MinAPIVersion': '1.12', 'Os': 'linux'}}, {'Name': 'containerd', 'Version': '1.7.18', 'Details': {'GitCommit': 'ae71819c4f5e67bb4d5ae76a6b735f29cc25774e'}}, {'Name': 'runc', 'Version': '1.7.18', 'Details': {'GitCommit': 'v1.1.13-0-g58aa920'}}, {'Name': 'docker-init', 'Version': '0.19.0', 'Details': {'GitCommit': 'de40ad0'}}], Version=23.0.6, ApiVersion=1.42, MinAPIVersion=1.12, GitCommit=9dbdbd4, GoVersion=go1.19.9, Os=linux, Arch=amd64, KernelVersion=5.15.0-130-generic, BuildTime=2023-05-05T21:18:13.000000000+00:00 (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker inspect_network <- ('roottestpostgresqlreplicadatabaseengine1_default') (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker info <- () (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker info -> {'Architecture': 'x86_64', (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr: 'BridgeNfIp6tables': True, (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr: 'BridgeNfIptables': True, (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr: 'CPUSet': True, (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr: 'CPUShares': True, (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr: 'CgroupDriver': 'cgroupfs', (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr: 'CgroupVersion': '2', (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr: 'ContainerdCommit': {'Expected': 'ae71819c4f5e67bb4d5ae76a6b735f29cc25774e', (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr: 'ID': 'ae71819c4f5e67bb4d5ae76a6b735f29cc25774e'}, (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr: 'Containers': 2, (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr:... (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker inspect_network <- ('roottestpostgresqlreplicadatabaseengine1_default') (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr:compose.network.ensure: Creating network "roottestpostgresqlreplicadatabaseengine1_default" with the default driver (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker create_network <- (name='roottestpostgresqlreplicadatabaseengine1_default', driver=None, options=None, ipam=None, internal=False, enable_ipv6=False, labels={'com.docker.compose.project': 'roottestpostgresqlreplicadatabaseengine1', 'com.docker.compose.network': 'default', 'com.docker.compose.version': '1.29.2'}, attachable=True, check_duplicate=True) (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker create_network -> {'Id': 'abd722f92060adf278fe7f8a7ee3b0b1950c913c3c138377f848edf41ffc7631', (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr: 'Warning': ''} (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers <- (all=False, filters={'label': ['com.docker.compose.project=roottestpostgresqlreplicadatabaseengine1', 'com.docker.compose.oneoff=False']}) (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers -> (list with 0 items) (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers <- (all=False, filters={'label': ['com.docker.compose.project=roottestpostgresqlreplicadatabaseengine1', 'com.docker.compose.oneoff=False']}) (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers -> (list with 0 items) (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers <- (all=True, filters={'label': ['com.docker.compose.project=roottestpostgresqlreplicadatabaseengine1', 'com.docker.compose.oneoff=False']}) (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers -> (list with 0 items) (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers <- (all=True, filters={'label': ['com.docker.compose.project=roottestpostgresqlreplicadatabaseengine1', 'com.docker.compose.oneoff=False']}) (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers -> (list with 0 items) (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers <- (all=True, filters={'label': ['com.docker.compose.project=roottestpostgresqlreplicadatabaseengine1', 'com.docker.compose.service=postgres1', 'com.docker.compose.oneoff=False']}) (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers -> (list with 0 items) (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers <- (all=True, filters={'label': ['com.docker.compose.project=roottestpostgresqlreplicadatabaseengine1', 'com.docker.compose.service=postgres1', 'com.docker.compose.oneoff=False']}) (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers -> (list with 0 items) (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker inspect_image <- ('postgres') (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker inspect_image -> {'Architecture': 'amd64', (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr: 'Author': '', (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr: 'Comment': 'buildkit.dockerfile.v0', (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr: 'Config': {'AttachStderr': False, (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr: 'AttachStdin': False, (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr: 'AttachStdout': False, (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr: 'Cmd': ['postgres'], (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr: 'Domainname': '', (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr: 'Entrypoint': ['docker-entrypoint.sh'], (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr: 'Env': ['PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/lib/postgresql/17/bin', (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr:... (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers <- (all=True, filters={'label': ['com.docker.compose.project=roottestpostgresqlreplicadatabaseengine1', 'com.docker.compose.service=postgres1', 'com.docker.compose.oneoff=False']}) (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers -> (list with 0 items) (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers <- (all=True, filters={'label': ['com.docker.compose.project=roottestpostgresqlreplicadatabaseengine1', 'com.docker.compose.service=postgres1', 'com.docker.compose.oneoff=False']}) (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers -> (list with 0 items) (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr:compose.parallel.feed_queue: Pending: {} (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr:compose.parallel.feed_queue: Starting producer thread for (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers <- (all=True, filters={'label': ['com.docker.compose.project=roottestpostgresqlreplicadatabaseengine1', 'com.docker.compose.service=postgres1', 'com.docker.compose.oneoff=False']}) (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers -> (list with 0 items) (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers <- (all=True, filters={'label': ['com.docker.compose.project=roottestpostgresqlreplicadatabaseengine1', 'com.docker.compose.service=postgres1', 'com.docker.compose.oneoff=False']}) (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers -> (list with 0 items) (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr:Creating roottestpostgresqlreplicadatabaseengine1_postgres1_1 ... (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr:compose.parallel.feed_queue: Pending: {ServiceName(project='roottestpostgresqlreplicadatabaseengine1', service='postgres1', number=1)} (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr:compose.parallel.feed_queue: Starting producer thread for ServiceName(project='roottestpostgresqlreplicadatabaseengine1', service='postgres1', number=1) (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker inspect_image <- ('postgres') (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker inspect_image -> {'Architecture': 'amd64', (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr: 'Author': '', (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr: 'Comment': 'buildkit.dockerfile.v0', (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr: 'Config': {'AttachStderr': False, (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr: 'AttachStdin': False, (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr: 'AttachStdout': False, (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr: 'Cmd': ['postgres'], (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr: 'Domainname': '', (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr: 'Entrypoint': ['docker-entrypoint.sh'], (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr: 'Env': ['PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/lib/postgresql/17/bin', (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr:... (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker inspect_image <- ('postgres') (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker inspect_image -> {'Architecture': 'amd64', (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr: 'Author': '', (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr: 'Comment': 'buildkit.dockerfile.v0', (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr: 'Config': {'AttachStderr': False, (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr: 'AttachStdin': False, (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr: 'AttachStdout': False, (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr: 'Cmd': ['postgres'], (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr: 'Domainname': '', (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr: 'Entrypoint': ['docker-entrypoint.sh'], (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr: 'Env': ['PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/lib/postgresql/17/bin', (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr:... (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr:compose.service.build_container_labels: Added config hash: 93968ec629d91980ea64eb0c7d74531b9606057f28d2f63fd9c8a6b21e104bb1 (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker create_host_config <- (links=[], port_bindings={}, binds=[], volumes_from=[], privileged=False, network_mode='roottestpostgresqlreplicadatabaseengine1_default', devices=None, device_requests=None, dns=None, dns_opt=None, dns_search=None, restart_policy={'Name': 'always', 'MaximumRetryCount': 0}, runtime=None, cap_add=None, cap_drop=None, mem_limit=None, mem_reservation=None, memswap_limit=None, ulimits=None, log_config={'Type': '', 'Config': {}}, extra_hosts=None, read_only=None, pid_mode=None, security_opt=None, ipc_mode=None, cgroup_parent=None, cpu_quota=None, shm_size=None, sysctls=None, pids_limit=None, tmpfs=None, oom_kill_disable=None, oom_score_adj=None, mem_swappiness=None, group_add=None, userns_mode=None, init=None, init_path=None, isolation=None, cpu_count=None, cpu_percent=None, nano_cpus=None, volume_driver=None, cpuset_cpus=None, cpu_shares=None, storage_opt=None, blkio_weight=None, blkio_weight_device=None, device_read_bps=None, device_read_iops=None, device_write_bps=None, device_write_iops=None, mounts=[{'Target': '/postgres/', 'Source': '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/postgres/postgres1', 'Type': 'bind', 'ReadOnly': None}], device_cgroup_rules=None, cpu_period=None, cpu_rt_period=None, cpu_rt_runtime=None) (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker create_host_config -> {'Binds': [], (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr: 'Links': [], (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr: 'LogConfig': {'Config': {}, 'Type': ''}, (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr: 'Mounts': [{'ReadOnly': None, (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr: 'Source': '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/postgres/postgres1', (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr: 'Target': '/postgres/', (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr: 'Type': 'bind'}], (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr: 'NetworkMode': 'roottestpostgresqlreplicadatabaseengine1_default', (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr: 'PortBindings': {}, (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr: 'RestartPolicy': {'MaximumRetryCount': 0, 'Name': 'always'}, (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr:... (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker create_container <- (command=['postgres', '-c', 'wal_level=logical', '-c', 'max_replication_slots=4', '-c', 'logging_collector=on', '-c', 'log_directory=/postgres/logs', '-c', 'log_filename=postgresql.log', '-c', 'log_statement=all', '-c', 'max_connections=200'], environment=['POSTGRES_HOST_AUTH_METHOD=trust', 'POSTGRES_PASSWORD=mysecretpassword', 'PGDATA=/postgres/data'], healthcheck={'test': ['CMD-SHELL', 'pg_isready -U postgres'], 'interval': 10000000000, 'timeout': 5000000000, 'retries': 5}, image='postgres', volumes={}, name='roottestpostgresqlreplicadatabaseengine1_postgres1_1', detach=True, ports=['5432'], labels={'com.docker.compose.project': 'roottestpostgresqlreplicadatabaseengine1', 'com.docker.compose.service': 'postgres1', 'com.docker.compose.oneoff': 'False', 'com.docker.compose.project.working_dir': '/ClickHouse/tests/integration/compose', 'com.docker.compose.project.config_files': '/ClickHouse/tests/integration/compose/docker_compose_postgres.yml', 'com.docker.compose.project.environment_file': '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/.env', 'com.docker.compose.container-number': '1', 'com.docker.compose.version': '1.29.2', 'com.docker.compose.config-hash': '93968ec629d91980ea64eb0c7d74531b9606057f28d2f63fd9c8a6b21e104bb1'}, host_config={'NetworkMode': 'roottestpostgresqlreplicadatabaseengine1_default', 'RestartPolicy': {'Name': 'always', 'MaximumRetryCount': 0}, 'VolumesFrom': [], 'Binds': [], 'PortBindings': {}, 'Links': [], 'LogConfig': {'Type': '', 'Config': {}}, 'Mounts': [{'Target': '/postgres/', 'Source': '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/postgres/postgres1', 'Type': 'bind', 'ReadOnly': None}]}, networking_config={'EndpointsConfig': {'roottestpostgresqlreplicadatabaseengine1_default': {'Aliases': ['postgres1', 'postgre-sql.local'], 'IPAMConfig': {}}}}) (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker create_container -> {'Id': '2f626e093c8aebac93ce63dedbe78597a8d44fd075ee1d2e09405b492caac01a', (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr: 'Warnings': []} (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker inspect_container <- ('2f626e093c8aebac93ce63dedbe78597a8d44fd075ee1d2e09405b492caac01a') (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker inspect_container -> {'AppArmorProfile': '', (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr: 'Args': ['postgres', (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr: '-c', (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr: 'wal_level=logical', (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr: '-c', (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr: 'max_replication_slots=4', (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr: '-c', (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr: 'logging_collector=on', (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr: '-c', (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr: 'log_directory=/postgres/logs', (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr:... (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker disconnect_container_from_network <- ('2f626e093c8aebac93ce63dedbe78597a8d44fd075ee1d2e09405b492caac01a', 'roottestpostgresqlreplicadatabaseengine1_default') (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker disconnect_container_from_network -> None (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker connect_container_to_network <- ('2f626e093c8aebac93ce63dedbe78597a8d44fd075ee1d2e09405b492caac01a', 'roottestpostgresqlreplicadatabaseengine1_default', aliases=['postgres1', 'postgre-sql.local', '2f626e093c8a'], ipv4_address=None, ipv6_address=None, links=[], link_local_ips=None) (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker connect_container_to_network -> None (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker start <- ('2f626e093c8aebac93ce63dedbe78597a8d44fd075ee1d2e09405b492caac01a') (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr:compose.parallel.feed_queue: Pending: set() (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr:compose.parallel.feed_queue: Pending: set() (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr:compose.parallel.feed_queue: Pending: set() (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr:compose.parallel.feed_queue: Pending: set() (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr:compose.parallel.feed_queue: Pending: set() (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr:compose.parallel.feed_queue: Pending: set() (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr:compose.parallel.feed_queue: Pending: set() (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr:compose.parallel.feed_queue: Pending: set() (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr:compose.parallel.feed_queue: Pending: set() (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr:compose.parallel.feed_queue: Pending: set() (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr:compose.parallel.feed_queue: Pending: set() (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr:compose.parallel.feed_queue: Pending: set() (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr:compose.parallel.feed_queue: Pending: set() (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr:compose.parallel.feed_queue: Pending: set() (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr:compose.parallel.feed_queue: Pending: set() (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr:compose.parallel.feed_queue: Pending: set() (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker start -> None (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr:compose.parallel.parallel_execute_iter: Finished processing: ServiceName(project='roottestpostgresqlreplicadatabaseengine1', service='postgres1', number=1) (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr:Creating roottestpostgresqlreplicadatabaseengine1_postgres1_1 ... done (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr:compose.parallel.feed_queue: Pending: set() (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr:compose.parallel.parallel_execute_iter: Finished processing: (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : Stderr:compose.parallel.feed_queue: Pending: set() (cluster.py:123, run_and_check) 2025-06-04 01:16:03 [ 520 ] DEBUG : get_instance_ip instance_name=postgres1 (cluster.py:2008, get_instance_ip) 2025-06-04 01:16:03 [ 520 ] DEBUG : http://localhost:None "GET /v1.42/containers/roottestpostgresqlreplicadatabaseengine1_postgres1_1/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2025-06-04 01:16:03 [ 520 ] DEBUG : Can't connect to Postgres connection to server at "172.16.4.2", port 5432 failed: Connection refused Is the server running on that host and accepting TCP/IP connections? (cluster.py:2251, wait_postgres_to_start) 2025-06-04 01:16:03 [ 520 ] DEBUG : Can't connect to Postgres connection to server at "172.16.4.2", port 5432 failed: Connection refused Is the server running on that host and accepting TCP/IP connections? (cluster.py:2251, wait_postgres_to_start) 2025-06-04 01:16:04 [ 520 ] DEBUG : Can't connect to Postgres connection to server at "172.16.4.2", port 5432 failed: Connection refused Is the server running on that host and accepting TCP/IP connections? (cluster.py:2251, wait_postgres_to_start) 2025-06-04 01:16:04 [ 520 ] DEBUG : Postgres Started (cluster.py:2248, wait_postgres_to_start) 2025-06-04 01:16:04 [ 520 ] DEBUG : ('Trying to create ClickHouse instance by command %s', 'docker-compose --env-file /ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/.env --project-name roottestpostgresqlreplicadatabaseengine1 --file /ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/instance/docker-compose.yml --file /ClickHouse/tests/integration/helpers/../../../tests/integration/compose/docker_compose_postgres.yml up -d --no-recreate') (cluster.py:3002, start) 2025-06-04 01:16:04 [ 520 ] DEBUG : Command:['docker-compose', '--env-file', '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/.env', '--project-name', 'roottestpostgresqlreplicadatabaseengine1', '--file', '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/instance/docker-compose.yml', '--file', '/ClickHouse/tests/integration/helpers/../../../tests/integration/compose/docker_compose_postgres.yml', 'up', '-d', '--no-recreate'] (cluster.py:113, run_and_check) 2025-06-04 01:16:05 [ 520 ] DEBUG : Stderr:Creating roottestpostgresqlreplicadatabaseengine1_instance_1 ... (cluster.py:123, run_and_check) 2025-06-04 01:16:05 [ 520 ] DEBUG : Stderr:Creating roottestpostgresqlreplicadatabaseengine1_instance_1 ... done (cluster.py:123, run_and_check) 2025-06-04 01:16:05 [ 520 ] DEBUG : ClickHouse instance created (cluster.py:3010, start) 2025-06-04 01:16:05 [ 520 ] DEBUG : get_instance_ip instance_name=instance (cluster.py:2008, get_instance_ip) 2025-06-04 01:16:05 [ 520 ] DEBUG : http://localhost:None "GET /v1.42/containers/roottestpostgresqlreplicadatabaseengine1_instance_1/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2025-06-04 01:16:05 [ 520 ] DEBUG : Waiting for ClickHouse start in instance, ip: 172.16.4.3... (cluster.py:3017, start) 2025-06-04 01:16:05 [ 520 ] DEBUG : http://localhost:None "GET /v1.42/containers/roottestpostgresqlreplicadatabaseengine1_instance_1/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2025-06-04 01:16:05 [ 520 ] DEBUG : http://localhost:None "GET /v1.42/containers/0d1c06220f0e0b9b7f75b10eb8cf0da3620284b4fe6c60091cdceae27ff52095/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2025-06-04 01:16:05 [ 520 ] DEBUG : http://localhost:None "GET /v1.42/containers/0d1c06220f0e0b9b7f75b10eb8cf0da3620284b4fe6c60091cdceae27ff52095/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2025-06-04 01:16:05 [ 520 ] DEBUG : http://localhost:None "GET /v1.42/containers/0d1c06220f0e0b9b7f75b10eb8cf0da3620284b4fe6c60091cdceae27ff52095/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2025-06-04 01:16:05 [ 520 ] DEBUG : http://localhost:None "GET /v1.42/containers/0d1c06220f0e0b9b7f75b10eb8cf0da3620284b4fe6c60091cdceae27ff52095/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2025-06-04 01:16:06 [ 520 ] DEBUG : http://localhost:None "GET /v1.42/containers/0d1c06220f0e0b9b7f75b10eb8cf0da3620284b4fe6c60091cdceae27ff52095/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2025-06-04 01:16:06 [ 520 ] DEBUG : http://localhost:None "GET /v1.42/containers/0d1c06220f0e0b9b7f75b10eb8cf0da3620284b4fe6c60091cdceae27ff52095/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2025-06-04 01:16:06 [ 520 ] DEBUG : http://localhost:None "GET /v1.42/containers/0d1c06220f0e0b9b7f75b10eb8cf0da3620284b4fe6c60091cdceae27ff52095/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2025-06-04 01:16:06 [ 520 ] DEBUG : http://localhost:None "GET /v1.42/containers/0d1c06220f0e0b9b7f75b10eb8cf0da3620284b4fe6c60091cdceae27ff52095/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2025-06-04 01:16:06 [ 520 ] DEBUG : http://localhost:None "GET /v1.42/containers/0d1c06220f0e0b9b7f75b10eb8cf0da3620284b4fe6c60091cdceae27ff52095/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2025-06-04 01:16:06 [ 520 ] DEBUG : http://localhost:None "GET /v1.42/containers/0d1c06220f0e0b9b7f75b10eb8cf0da3620284b4fe6c60091cdceae27ff52095/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2025-06-04 01:16:06 [ 520 ] DEBUG : http://localhost:None "GET /v1.42/containers/0d1c06220f0e0b9b7f75b10eb8cf0da3620284b4fe6c60091cdceae27ff52095/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2025-06-04 01:16:06 [ 520 ] DEBUG : http://localhost:None "GET /v1.42/containers/0d1c06220f0e0b9b7f75b10eb8cf0da3620284b4fe6c60091cdceae27ff52095/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2025-06-04 01:16:06 [ 520 ] DEBUG : http://localhost:None "GET /v1.42/containers/0d1c06220f0e0b9b7f75b10eb8cf0da3620284b4fe6c60091cdceae27ff52095/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2025-06-04 01:16:06 [ 520 ] DEBUG : http://localhost:None "GET /v1.42/containers/0d1c06220f0e0b9b7f75b10eb8cf0da3620284b4fe6c60091cdceae27ff52095/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2025-06-04 01:16:07 [ 520 ] DEBUG : http://localhost:None "GET /v1.42/containers/0d1c06220f0e0b9b7f75b10eb8cf0da3620284b4fe6c60091cdceae27ff52095/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2025-06-04 01:16:07 [ 520 ] DEBUG : http://localhost:None "GET /v1.42/containers/0d1c06220f0e0b9b7f75b10eb8cf0da3620284b4fe6c60091cdceae27ff52095/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2025-06-04 01:16:07 [ 520 ] DEBUG : http://localhost:None "GET /v1.42/containers/0d1c06220f0e0b9b7f75b10eb8cf0da3620284b4fe6c60091cdceae27ff52095/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2025-06-04 01:16:07 [ 520 ] DEBUG : http://localhost:None "GET /v1.42/containers/0d1c06220f0e0b9b7f75b10eb8cf0da3620284b4fe6c60091cdceae27ff52095/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2025-06-04 01:16:07 [ 520 ] DEBUG : http://localhost:None "GET /v1.42/containers/0d1c06220f0e0b9b7f75b10eb8cf0da3620284b4fe6c60091cdceae27ff52095/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2025-06-04 01:16:07 [ 520 ] DEBUG : http://localhost:None "GET /v1.42/containers/0d1c06220f0e0b9b7f75b10eb8cf0da3620284b4fe6c60091cdceae27ff52095/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2025-06-04 01:16:07 [ 520 ] DEBUG : http://localhost:None "GET /v1.42/containers/0d1c06220f0e0b9b7f75b10eb8cf0da3620284b4fe6c60091cdceae27ff52095/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2025-06-04 01:16:07 [ 520 ] DEBUG : http://localhost:None "GET /v1.42/containers/0d1c06220f0e0b9b7f75b10eb8cf0da3620284b4fe6c60091cdceae27ff52095/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2025-06-04 01:16:07 [ 520 ] DEBUG : http://localhost:None "GET /v1.42/containers/0d1c06220f0e0b9b7f75b10eb8cf0da3620284b4fe6c60091cdceae27ff52095/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2025-06-04 01:16:07 [ 520 ] DEBUG : ClickHouse instance started (cluster.py:3021, start) 2025-06-04 01:16:07 [ 520 ] DEBUG : Executing query DROP DATABASE IF EXISTS "postgres_database" on instance (cluster.py:3455, query) 2025-06-04 01:16:08 [ 520 ] DEBUG : Executing query CREATE DATABASE "postgres_database" ENGINE = PostgreSQL('172.16.4.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') on instance (cluster.py:3455, query) ----------------------------- Captured stdout call ----------------------------- Query: CREATE TABLE IF NOT EXISTS "postgresql_replica_0" ( key Integer NOT NULL, value Integer, PRIMARY KEY(key)) Query: CREATE TABLE IF NOT EXISTS "postgresql_replica_1" ( key Integer NOT NULL, value Integer, PRIMARY KEY(key)) Query: CREATE TABLE IF NOT EXISTS "postgresql_replica_2" ( key Integer NOT NULL, value Integer, PRIMARY KEY(key)) Query: CREATE TABLE IF NOT EXISTS "postgresql_replica_3" ( key Integer NOT NULL, value Integer, PRIMARY KEY(key)) Query: CREATE TABLE IF NOT EXISTS "postgresql_replica_4" ( key Integer NOT NULL, value Integer, PRIMARY KEY(key)) Checking table postgresql_replica_0 exists in test_database Checking table is synchronized: test_database.postgresql_replica_0 ----------------------------- Captured stderr call ----------------------------- Executing query INSERT INTO postgres_database.postgresql_replica_0 SELECT number, 0 from numbers(50) on instance Executing query INSERT INTO postgres_database.postgresql_replica_1 SELECT number, 1 from numbers(50) on instance Executing query INSERT INTO postgres_database.postgresql_replica_2 SELECT number, 2 from numbers(50) on instance Executing query INSERT INTO postgres_database.postgresql_replica_3 SELECT number, 3 from numbers(50) on instance Executing query INSERT INTO postgres_database.postgresql_replica_4 SELECT number, 4 from numbers(50) on instance Executing query DROP DATABASE IF EXISTS `test_database` on instance Executing query CREATE DATABASE `test_database` ENGINE = MaterializedPostgreSQL('172.16.4.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') on instance Executing query SHOW DATABASES on instance Executing query INSERT INTO postgres_database.postgresql_replica_0 SELECT 50 + number, 0 from numbers(1000) on instance Executing query INSERT INTO postgres_database.postgresql_replica_1 SELECT 50 + number, 1 from numbers(1000) on instance Executing query INSERT INTO postgres_database.postgresql_replica_2 SELECT 50 + number, 2 from numbers(1000) on instance Executing query INSERT INTO postgres_database.postgresql_replica_3 SELECT 50 + number, 3 from numbers(1000) on instance Executing query INSERT INTO postgres_database.postgresql_replica_4 SELECT 50 + number, 4 from numbers(1000) on instance Executing query SHOW TABLES FROM `test_database` on instance Executing query select * from `postgres_database`.`postgresql_replica_0` order by key; on instance Executing query select * from `test_database.postgresql_replica_0` order by key; on instance ------------------------------ Captured log call ------------------------------- 2025-06-04 01:16:08 [ 520 ] DEBUG : Executing query INSERT INTO postgres_database.postgresql_replica_0 SELECT number, 0 from numbers(50) on instance (cluster.py:3455, query) 2025-06-04 01:16:08 [ 520 ] DEBUG : Executing query INSERT INTO postgres_database.postgresql_replica_1 SELECT number, 1 from numbers(50) on instance (cluster.py:3455, query) 2025-06-04 01:16:08 [ 520 ] DEBUG : Executing query INSERT INTO postgres_database.postgresql_replica_2 SELECT number, 2 from numbers(50) on instance (cluster.py:3455, query) 2025-06-04 01:16:09 [ 520 ] DEBUG : Executing query INSERT INTO postgres_database.postgresql_replica_3 SELECT number, 3 from numbers(50) on instance (cluster.py:3455, query) 2025-06-04 01:16:09 [ 520 ] DEBUG : Executing query INSERT INTO postgres_database.postgresql_replica_4 SELECT number, 4 from numbers(50) on instance (cluster.py:3455, query) 2025-06-04 01:16:09 [ 520 ] DEBUG : Executing query DROP DATABASE IF EXISTS `test_database` on instance (cluster.py:3455, query) 2025-06-04 01:16:09 [ 520 ] DEBUG : Executing query CREATE DATABASE `test_database` ENGINE = MaterializedPostgreSQL('172.16.4.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') on instance (cluster.py:3455, query) 2025-06-04 01:16:09 [ 520 ] DEBUG : Executing query SHOW DATABASES on instance (cluster.py:3455, query) 2025-06-04 01:16:10 [ 520 ] DEBUG : Executing query INSERT INTO postgres_database.postgresql_replica_0 SELECT 50 + number, 0 from numbers(1000) on instance (cluster.py:3455, query) 2025-06-04 01:16:10 [ 520 ] DEBUG : Executing query INSERT INTO postgres_database.postgresql_replica_1 SELECT 50 + number, 1 from numbers(1000) on instance (cluster.py:3455, query) 2025-06-04 01:16:10 [ 520 ] DEBUG : Executing query INSERT INTO postgres_database.postgresql_replica_2 SELECT 50 + number, 2 from numbers(1000) on instance (cluster.py:3455, query) 2025-06-04 01:16:10 [ 520 ] DEBUG : Executing query INSERT INTO postgres_database.postgresql_replica_3 SELECT 50 + number, 3 from numbers(1000) on instance (cluster.py:3455, query) 2025-06-04 01:16:10 [ 520 ] DEBUG : Executing query INSERT INTO postgres_database.postgresql_replica_4 SELECT 50 + number, 4 from numbers(1000) on instance (cluster.py:3455, query) 2025-06-04 01:16:11 [ 520 ] DEBUG : Executing query SHOW TABLES FROM `test_database` on instance (cluster.py:3455, query) 2025-06-04 01:16:11 [ 520 ] DEBUG : Executing query select * from `postgres_database`.`postgresql_replica_0` order by key; on instance (cluster.py:3455, query) 2025-06-04 01:16:11 [ 520 ] DEBUG : Executing query select * from `test_database.postgresql_replica_0` order by key; on instance (cluster.py:3455, query) --------------------------- Captured stderr teardown --------------------------- Executing query DROP DATABASE IF EXISTS `test_database` SYNC on instance Executing query DROP DATABASE IF EXISTS "postgres_database" on instance Executing query DROP DATABASE IF EXISTS "postgres_database" on instance Executing query CREATE DATABASE "postgres_database" ENGINE = PostgreSQL('172.16.4.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') on instance ---------------------------- Captured log teardown ----------------------------- 2025-06-04 01:16:11 [ 520 ] DEBUG : Executing query DROP DATABASE IF EXISTS `test_database` SYNC on instance (cluster.py:3455, query) 2025-06-04 01:16:12 [ 520 ] DEBUG : Executing query DROP DATABASE IF EXISTS "postgres_database" on instance (cluster.py:3455, query) 2025-06-04 01:16:12 [ 520 ] DEBUG : Executing query DROP DATABASE IF EXISTS "postgres_database" on instance (cluster.py:3455, query) 2025-06-04 01:16:12 [ 520 ] DEBUG : Executing query CREATE DATABASE "postgres_database" ENGINE = PostgreSQL('172.16.4.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') on instance (cluster.py:3455, query) __________ test_restart_server_while_replication_startup_not_finished __________ [gw3] linux -- Python 3.10.12 /usr/bin/python3 started_cluster = def test_restart_server_while_replication_startup_not_finished(started_cluster): NUM_TABLES = 5 pg_manager.create_and_fill_postgres_tables(NUM_TABLES, 100000) pg_manager.create_materialized_db( ip=started_cluster.postgres_ip, port=started_cluster.postgres_port ) time.sleep(1) instance.restart_clickhouse() > check_several_tables_are_synchronized(instance, NUM_TABLES) test_postgresql_replica_database_engine_1/test.py:774: _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ helpers/postgres_utility.py:419: in check_several_tables_are_synchronized check_tables_are_synchronized( helpers/postgres_utility.py:392: in check_tables_are_synchronized result = instance.query(result_query) helpers/cluster.py:3456: in query return self.client.query( helpers/client.py:36: in wrap return func(self, *args, **kwargs) helpers/client.py:74: in query ).get_answer() _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ self = def get_answer(self): self.process.wait(timeout=DEFAULT_QUERY_TIMEOUT) self.stdout_file.seek(0) self.stderr_file.seek(0) stdout = self.stdout_file.read().decode("utf-8", errors="replace") stderr = self.stderr_file.read().decode("utf-8", errors="replace") if ( self.timer is not None and not self.process_finished_before_timeout and not self.ignore_error ): logging.debug(f"Timed out. Last stdout:{stdout}, stderr:{stderr}") raise QueryTimeoutExceedException("Client timed out!") if ( self.process.returncode != 0 or self.remove_trash_from_stderr(stderr) ) and not self.ignore_error: > raise QueryRuntimeException( "Client failed! Return code: {}, stderr: {}".format( self.process.returncode, stderr ), self.process.returncode, stderr, ) E helpers.client.QueryRuntimeException: Client failed! Return code: 60, stderr: Received exception from server (version 24.3.18): E Code: 60. DB::Exception: Received from 172.16.4.3:9000. DB::Exception: Unknown table expression identifier 'test_database.postgresql_replica_0' in scope SELECT * FROM `test_database.postgresql_replica_0` ORDER BY key ASC. Stack trace: E E 0. ./contrib/llvm-project/libcxx/include/exception:141: Poco::Exception::Exception(String const&, int) @ 0x000000003a50df73 E 1. ./build_docker/./src/Common/Exception.cpp:96: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000001cb3f630 E 2. DB::Exception::Exception(int, FormatStringHelperImpl::type, std::type_identity::type>, String const&, String&&) @ 0x000000000c5b9b76 E 3. ./build_docker/./src/Analyzer/Passes/QueryAnalysisPass.cpp:6971: DB::(anonymous namespace)::QueryAnalyzer::resolveQuery(std::shared_ptr const&, DB::(anonymous namespace)::IdentifierResolveScope&) @ 0x000000002db7d229 E 4. ./build_docker/./src/Analyzer/Passes/QueryAnalysisPass.cpp:0: DB::QueryAnalysisPass::run(std::shared_ptr&, std::shared_ptr) @ 0x000000002db6e577 E 5. ./build_docker/./src/Analyzer/QueryTreePassManager.cpp:0: DB::QueryTreePassManager::run(std::shared_ptr) @ 0x000000002db6562e E 6. ./build_docker/./src/Interpreters/InterpreterSelectQueryAnalyzer.cpp:0: DB::(anonymous namespace)::buildQueryTreeAndRunPasses(std::shared_ptr const&, DB::SelectQueryOptions const&, std::shared_ptr const&, std::shared_ptr const&) @ 0x000000002e5acbd6 E 7. ./build_docker/./src/Interpreters/InterpreterSelectQueryAnalyzer.cpp:160: DB::InterpreterSelectQueryAnalyzer::InterpreterSelectQueryAnalyzer(std::shared_ptr const&, std::shared_ptr const&, DB::SelectQueryOptions const&, std::vector> const&) @ 0x000000002e5a56f4 E 8. ./contrib/llvm-project/libcxx/include/__memory/unique_ptr.h:0: std::__unique_if::__unique_single std::make_unique[abi:v15000]&, std::shared_ptr const&, DB::SelectQueryOptions const&>(std::shared_ptr&, std::shared_ptr const&, DB::SelectQueryOptions const&) @ 0x000000002e5b0821 E 9. ./contrib/llvm-project/libcxx/include/__functional/function.h:0: ? @ 0x000000002e46175d E 10. ./build_docker/./src/Interpreters/executeQuery.cpp:0: DB::executeQueryImpl(char const*, char const*, std::shared_ptr, DB::QueryFlags, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x000000002f1e6e0a E 11. ./build_docker/./src/Interpreters/executeQuery.cpp:1376: DB::executeQuery(String const&, std::shared_ptr, DB::QueryFlags, DB::QueryProcessingStage::Enum) @ 0x000000002f1dde8a E 12. ./contrib/llvm-project/libcxx/include/__memory/shared_ptr.h:612: DB::TCPHandler::runImpl() @ 0x00000000326e9c5d E 13. ./build_docker/./src/Server/TCPHandler.cpp:2341: DB::TCPHandler::run() @ 0x000000003272e6b1 E 14. ./build_docker/./base/poco/Net/src/TCPServerConnection.cpp:57: Poco::Net::TCPServerConnection::start() @ 0x000000003a2162af E 15. ./contrib/llvm-project/libcxx/include/__memory/unique_ptr.h:48: Poco::Net::TCPServerDispatcher::run() @ 0x000000003a216f57 E 16. ./build_docker/./base/poco/Foundation/src/ThreadPool.cpp:0: Poco::PooledThread::run() @ 0x000000003a623f3c E 17. ./base/poco/Foundation/include/Poco/SharedPtr.h:231: Poco::ThreadImpl::runnableEntry(void*) @ 0x000000003a61cf28 E 18. asan_thread_start(void*) @ 0x000000000a7b049b E 19. ? @ 0x00007f5b28be6ac3 E 20. ? @ 0x00007f5b28c78850 E . (UNKNOWN_TABLE) E (query: select * from `test_database.postgresql_replica_0` order by key;) helpers/client.py:239: QueryRuntimeException ---------------------------- Captured stdout setup ----------------------------- PostgreSQL is available - running test ----------------------------- Captured stdout call ----------------------------- Query: CREATE TABLE IF NOT EXISTS "postgresql_replica_0" ( key Integer NOT NULL, value Integer, PRIMARY KEY(key)) Query: CREATE TABLE IF NOT EXISTS "postgresql_replica_1" ( key Integer NOT NULL, value Integer, PRIMARY KEY(key)) Query: CREATE TABLE IF NOT EXISTS "postgresql_replica_2" ( key Integer NOT NULL, value Integer, PRIMARY KEY(key)) Query: CREATE TABLE IF NOT EXISTS "postgresql_replica_3" ( key Integer NOT NULL, value Integer, PRIMARY KEY(key)) Query: CREATE TABLE IF NOT EXISTS "postgresql_replica_4" ( key Integer NOT NULL, value Integer, PRIMARY KEY(key)) Checking table postgresql_replica_0 exists in test_database Checking table is synchronized: test_database.postgresql_replica_0 ----------------------------- Captured stderr call ----------------------------- Executing query INSERT INTO `postgres_database`.`postgresql_replica_0` SELECT number, number from numbers(100000) on instance Executing query INSERT INTO `postgres_database`.`postgresql_replica_1` SELECT number, number from numbers(100000) on instance Executing query INSERT INTO `postgres_database`.`postgresql_replica_2` SELECT number, number from numbers(100000) on instance Executing query INSERT INTO `postgres_database`.`postgresql_replica_3` SELECT number, number from numbers(100000) on instance Executing query INSERT INTO `postgres_database`.`postgresql_replica_4` SELECT number, number from numbers(100000) on instance Executing query DROP DATABASE IF EXISTS `test_database` on instance Executing query CREATE DATABASE `test_database` ENGINE = MaterializedPostgreSQL('172.16.4.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') on instance Executing query SHOW DATABASES on instance run container_id:roottestpostgresqlreplicadatabaseengine1_instance_1 detach:False nothrow:True cmd: ['bash', '-c', 'ps -C clickhouse'] Command:['docker', 'exec', '-u', 'root', 'roottestpostgresqlreplicadatabaseengine1_instance_1', 'bash', '-c', 'ps -C clickhouse'] Stdout: PID TTY TIME CMD Stdout: 8 ? 00:00:06 clickhouse run container_id:roottestpostgresqlreplicadatabaseengine1_instance_1 detach:False nothrow:False cmd: ['bash', '-c', 'pkill clickhouse'] Command:['docker', 'exec', '-u', 'root', 'roottestpostgresqlreplicadatabaseengine1_instance_1', 'bash', '-c', 'pkill clickhouse'] run container_id:roottestpostgresqlreplicadatabaseengine1_instance_1 detach:False nothrow:False cmd: ['bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] Command:['docker', 'exec', 'roottestpostgresqlreplicadatabaseengine1_instance_1', 'bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] Stdout:8 run container_id:roottestpostgresqlreplicadatabaseengine1_instance_1 detach:False nothrow:False cmd: ['bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] Command:['docker', 'exec', 'roottestpostgresqlreplicadatabaseengine1_instance_1', 'bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] Stdout:8 run container_id:roottestpostgresqlreplicadatabaseengine1_instance_1 detach:False nothrow:False cmd: ['bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] Command:['docker', 'exec', 'roottestpostgresqlreplicadatabaseengine1_instance_1', 'bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] run container_id:roottestpostgresqlreplicadatabaseengine1_instance_1 detach:False nothrow:False cmd: ['bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] Command:['docker', 'exec', 'roottestpostgresqlreplicadatabaseengine1_instance_1', 'bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] No clickhouse process running. Start new one. run container_id:roottestpostgresqlreplicadatabaseengine1_instance_1 detach:False nothrow:False cmd: ['bash', '-c', 'clickhouse server --config-file=/etc/clickhouse-server/config.xml --log-file=/var/log/clickhouse-server/clickhouse-server.log --errorlog-file=/var/log/clickhouse-server/clickhouse-server.err.log --daemon'] Command:['docker', 'exec', '-u', '0', 'roottestpostgresqlreplicadatabaseengine1_instance_1', 'bash', '-c', 'clickhouse server --config-file=/etc/clickhouse-server/config.xml --log-file=/var/log/clickhouse-server/clickhouse-server.log --errorlog-file=/var/log/clickhouse-server/clickhouse-server.err.log --daemon'] run container_id:roottestpostgresqlreplicadatabaseengine1_instance_1 detach:False nothrow:False cmd: ['bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] Command:['docker', 'exec', 'roottestpostgresqlreplicadatabaseengine1_instance_1', 'bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] Stdout:753 Clickhouse process running. run container_id:roottestpostgresqlreplicadatabaseengine1_instance_1 detach:False nothrow:False cmd: ['bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] Command:['docker', 'exec', 'roottestpostgresqlreplicadatabaseengine1_instance_1', 'bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] Stdout:753 Executing query select 20 on instance Executing query select 20 on instance Executing query select 20 on instance Executing query select 20 on instance Executing query SHOW TABLES FROM `test_database` on instance Executing query select * from `postgres_database`.`postgresql_replica_0` order by key; on instance Executing query select * from `test_database.postgresql_replica_0` order by key; on instance ------------------------------ Captured log call ------------------------------- 2025-06-04 01:16:12 [ 520 ] DEBUG : Executing query INSERT INTO `postgres_database`.`postgresql_replica_0` SELECT number, number from numbers(100000) on instance (cluster.py:3455, query) 2025-06-04 01:16:13 [ 520 ] DEBUG : Executing query INSERT INTO `postgres_database`.`postgresql_replica_1` SELECT number, number from numbers(100000) on instance (cluster.py:3455, query) 2025-06-04 01:16:13 [ 520 ] DEBUG : Executing query INSERT INTO `postgres_database`.`postgresql_replica_2` SELECT number, number from numbers(100000) on instance (cluster.py:3455, query) 2025-06-04 01:16:14 [ 520 ] DEBUG : Executing query INSERT INTO `postgres_database`.`postgresql_replica_3` SELECT number, number from numbers(100000) on instance (cluster.py:3455, query) 2025-06-04 01:16:15 [ 520 ] DEBUG : Executing query INSERT INTO `postgres_database`.`postgresql_replica_4` SELECT number, number from numbers(100000) on instance (cluster.py:3455, query) 2025-06-04 01:16:15 [ 520 ] DEBUG : Executing query DROP DATABASE IF EXISTS `test_database` on instance (cluster.py:3455, query) 2025-06-04 01:16:16 [ 520 ] DEBUG : Executing query CREATE DATABASE `test_database` ENGINE = MaterializedPostgreSQL('172.16.4.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') on instance (cluster.py:3455, query) 2025-06-04 01:16:16 [ 520 ] DEBUG : Executing query SHOW DATABASES on instance (cluster.py:3455, query) 2025-06-04 01:16:17 [ 520 ] DEBUG : run container_id:roottestpostgresqlreplicadatabaseengine1_instance_1 detach:False nothrow:True cmd: ['bash', '-c', 'ps -C clickhouse'] (cluster.py:2046, exec_in_container) 2025-06-04 01:16:17 [ 520 ] DEBUG : Command:['docker', 'exec', '-u', 'root', 'roottestpostgresqlreplicadatabaseengine1_instance_1', 'bash', '-c', 'ps -C clickhouse'] (cluster.py:113, run_and_check) 2025-06-04 01:16:17 [ 520 ] DEBUG : Stdout: PID TTY TIME CMD (cluster.py:121, run_and_check) 2025-06-04 01:16:17 [ 520 ] DEBUG : Stdout: 8 ? 00:00:06 clickhouse (cluster.py:121, run_and_check) 2025-06-04 01:16:17 [ 520 ] DEBUG : run container_id:roottestpostgresqlreplicadatabaseengine1_instance_1 detach:False nothrow:False cmd: ['bash', '-c', 'pkill clickhouse'] (cluster.py:2046, exec_in_container) 2025-06-04 01:16:17 [ 520 ] DEBUG : Command:['docker', 'exec', '-u', 'root', 'roottestpostgresqlreplicadatabaseengine1_instance_1', 'bash', '-c', 'pkill clickhouse'] (cluster.py:113, run_and_check) 2025-06-04 01:16:17 [ 520 ] DEBUG : run container_id:roottestpostgresqlreplicadatabaseengine1_instance_1 detach:False nothrow:False cmd: ['bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] (cluster.py:2046, exec_in_container) 2025-06-04 01:16:17 [ 520 ] DEBUG : Command:['docker', 'exec', 'roottestpostgresqlreplicadatabaseengine1_instance_1', 'bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] (cluster.py:113, run_and_check) 2025-06-04 01:16:17 [ 520 ] DEBUG : Stdout:8 (cluster.py:121, run_and_check) 2025-06-04 01:16:18 [ 520 ] DEBUG : run container_id:roottestpostgresqlreplicadatabaseengine1_instance_1 detach:False nothrow:False cmd: ['bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] (cluster.py:2046, exec_in_container) 2025-06-04 01:16:18 [ 520 ] DEBUG : Command:['docker', 'exec', 'roottestpostgresqlreplicadatabaseengine1_instance_1', 'bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] (cluster.py:113, run_and_check) 2025-06-04 01:16:18 [ 520 ] DEBUG : Stdout:8 (cluster.py:121, run_and_check) 2025-06-04 01:16:19 [ 520 ] DEBUG : run container_id:roottestpostgresqlreplicadatabaseengine1_instance_1 detach:False nothrow:False cmd: ['bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] (cluster.py:2046, exec_in_container) 2025-06-04 01:16:19 [ 520 ] DEBUG : Command:['docker', 'exec', 'roottestpostgresqlreplicadatabaseengine1_instance_1', 'bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] (cluster.py:113, run_and_check) 2025-06-04 01:16:19 [ 520 ] DEBUG : run container_id:roottestpostgresqlreplicadatabaseengine1_instance_1 detach:False nothrow:False cmd: ['bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] (cluster.py:2046, exec_in_container) 2025-06-04 01:16:19 [ 520 ] DEBUG : Command:['docker', 'exec', 'roottestpostgresqlreplicadatabaseengine1_instance_1', 'bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] (cluster.py:113, run_and_check) 2025-06-04 01:16:19 [ 520 ] DEBUG : No clickhouse process running. Start new one. (cluster.py:3817, start_clickhouse) 2025-06-04 01:16:19 [ 520 ] DEBUG : run container_id:roottestpostgresqlreplicadatabaseengine1_instance_1 detach:False nothrow:False cmd: ['bash', '-c', 'clickhouse server --config-file=/etc/clickhouse-server/config.xml --log-file=/var/log/clickhouse-server/clickhouse-server.log --errorlog-file=/var/log/clickhouse-server/clickhouse-server.err.log --daemon'] (cluster.py:2046, exec_in_container) 2025-06-04 01:16:19 [ 520 ] DEBUG : Command:['docker', 'exec', '-u', '0', 'roottestpostgresqlreplicadatabaseengine1_instance_1', 'bash', '-c', 'clickhouse server --config-file=/etc/clickhouse-server/config.xml --log-file=/var/log/clickhouse-server/clickhouse-server.log --errorlog-file=/var/log/clickhouse-server/clickhouse-server.err.log --daemon'] (cluster.py:113, run_and_check) 2025-06-04 01:16:20 [ 520 ] DEBUG : run container_id:roottestpostgresqlreplicadatabaseengine1_instance_1 detach:False nothrow:False cmd: ['bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] (cluster.py:2046, exec_in_container) 2025-06-04 01:16:20 [ 520 ] DEBUG : Command:['docker', 'exec', 'roottestpostgresqlreplicadatabaseengine1_instance_1', 'bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] (cluster.py:113, run_and_check) 2025-06-04 01:16:21 [ 520 ] DEBUG : Stdout:753 (cluster.py:121, run_and_check) 2025-06-04 01:16:21 [ 520 ] DEBUG : Clickhouse process running. (cluster.py:3828, start_clickhouse) 2025-06-04 01:16:21 [ 520 ] DEBUG : run container_id:roottestpostgresqlreplicadatabaseengine1_instance_1 detach:False nothrow:False cmd: ['bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] (cluster.py:2046, exec_in_container) 2025-06-04 01:16:21 [ 520 ] DEBUG : Command:['docker', 'exec', 'roottestpostgresqlreplicadatabaseengine1_instance_1', 'bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] (cluster.py:113, run_and_check) 2025-06-04 01:16:21 [ 520 ] DEBUG : Stdout:753 (cluster.py:121, run_and_check) 2025-06-04 01:16:21 [ 520 ] DEBUG : Executing query select 20 on instance (cluster.py:3455, query) 2025-06-04 01:16:21 [ 520 ] DEBUG : Executing query select 20 on instance (cluster.py:3455, query) 2025-06-04 01:16:22 [ 520 ] DEBUG : Executing query select 20 on instance (cluster.py:3455, query) 2025-06-04 01:16:22 [ 520 ] DEBUG : Executing query select 20 on instance (cluster.py:3455, query) 2025-06-04 01:16:23 [ 520 ] DEBUG : Executing query SHOW TABLES FROM `test_database` on instance (cluster.py:3455, query) 2025-06-04 01:16:23 [ 520 ] DEBUG : Executing query select * from `postgres_database`.`postgresql_replica_0` order by key; on instance (cluster.py:3455, query) 2025-06-04 01:16:23 [ 520 ] DEBUG : Executing query select * from `test_database.postgresql_replica_0` order by key; on instance (cluster.py:3455, query) --------------------------- Captured stderr teardown --------------------------- Executing query DROP DATABASE IF EXISTS `test_database` SYNC on instance Executing query DROP DATABASE IF EXISTS "postgres_database" on instance Executing query DROP DATABASE IF EXISTS "postgres_database" on instance Executing query CREATE DATABASE "postgres_database" ENGINE = PostgreSQL('172.16.4.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') on instance ---------------------------- Captured log teardown ----------------------------- 2025-06-04 01:16:24 [ 520 ] DEBUG : Executing query DROP DATABASE IF EXISTS `test_database` SYNC on instance (cluster.py:3455, query) 2025-06-04 01:16:24 [ 520 ] DEBUG : Executing query DROP DATABASE IF EXISTS "postgres_database" on instance (cluster.py:3455, query) 2025-06-04 01:16:24 [ 520 ] DEBUG : Executing query DROP DATABASE IF EXISTS "postgres_database" on instance (cluster.py:3455, query) 2025-06-04 01:16:24 [ 520 ] DEBUG : Executing query CREATE DATABASE "postgres_database" ENGINE = PostgreSQL('172.16.4.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') on instance (cluster.py:3455, query) ___________________________ test_single_transaction ____________________________ [gw3] linux -- Python 3.10.12 /usr/bin/python3 started_cluster = def test_single_transaction(started_cluster): conn = get_postgres_conn( ip=started_cluster.postgres_ip, port=started_cluster.postgres_port, database=True, auto_commit=False, ) cursor = conn.cursor() table_name = "postgresql_replica_0" create_postgres_table(cursor, table_name) conn.commit() pg_manager.create_materialized_db( ip=started_cluster.postgres_ip, port=started_cluster.postgres_port ) assert_nested_table_is_created(instance, table_name) for query in queries: print("query {}".format(query)) cursor.execute(query.format(0)) time.sleep(5) result = instance.query(f"select count() from test_database.{table_name}") # no commit yet assert int(result) == 0 conn.commit() > check_tables_are_synchronized(instance, table_name) test_postgresql_replica_database_engine_1/test.py:531: _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ helpers/postgres_utility.py:392: in check_tables_are_synchronized result = instance.query(result_query) helpers/cluster.py:3456: in query return self.client.query( helpers/client.py:36: in wrap return func(self, *args, **kwargs) helpers/client.py:74: in query ).get_answer() _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ self = def get_answer(self): self.process.wait(timeout=DEFAULT_QUERY_TIMEOUT) self.stdout_file.seek(0) self.stderr_file.seek(0) stdout = self.stdout_file.read().decode("utf-8", errors="replace") stderr = self.stderr_file.read().decode("utf-8", errors="replace") if ( self.timer is not None and not self.process_finished_before_timeout and not self.ignore_error ): logging.debug(f"Timed out. Last stdout:{stdout}, stderr:{stderr}") raise QueryTimeoutExceedException("Client timed out!") if ( self.process.returncode != 0 or self.remove_trash_from_stderr(stderr) ) and not self.ignore_error: > raise QueryRuntimeException( "Client failed! Return code: {}, stderr: {}".format( self.process.returncode, stderr ), self.process.returncode, stderr, ) E helpers.client.QueryRuntimeException: Client failed! Return code: 60, stderr: Received exception from server (version 24.3.18): E Code: 60. DB::Exception: Received from 172.16.4.3:9000. DB::Exception: Unknown table expression identifier 'test_database.postgresql_replica_0' in scope SELECT * FROM `test_database.postgresql_replica_0` ORDER BY key ASC. Stack trace: E E 0. ./contrib/llvm-project/libcxx/include/exception:141: Poco::Exception::Exception(String const&, int) @ 0x000000003a50df73 E 1. ./build_docker/./src/Common/Exception.cpp:96: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000001cb3f630 E 2. DB::Exception::Exception(int, FormatStringHelperImpl::type, std::type_identity::type>, String const&, String&&) @ 0x000000000c5b9b76 E 3. ./build_docker/./src/Analyzer/Passes/QueryAnalysisPass.cpp:6971: DB::(anonymous namespace)::QueryAnalyzer::resolveQuery(std::shared_ptr const&, DB::(anonymous namespace)::IdentifierResolveScope&) @ 0x000000002db7d229 E 4. ./build_docker/./src/Analyzer/Passes/QueryAnalysisPass.cpp:0: DB::QueryAnalysisPass::run(std::shared_ptr&, std::shared_ptr) @ 0x000000002db6e577 E 5. ./build_docker/./src/Analyzer/QueryTreePassManager.cpp:0: DB::QueryTreePassManager::run(std::shared_ptr) @ 0x000000002db6562e E 6. ./build_docker/./src/Interpreters/InterpreterSelectQueryAnalyzer.cpp:0: DB::(anonymous namespace)::buildQueryTreeAndRunPasses(std::shared_ptr const&, DB::SelectQueryOptions const&, std::shared_ptr const&, std::shared_ptr const&) @ 0x000000002e5acbd6 E 7. ./build_docker/./src/Interpreters/InterpreterSelectQueryAnalyzer.cpp:160: DB::InterpreterSelectQueryAnalyzer::InterpreterSelectQueryAnalyzer(std::shared_ptr const&, std::shared_ptr const&, DB::SelectQueryOptions const&, std::vector> const&) @ 0x000000002e5a56f4 E 8. ./contrib/llvm-project/libcxx/include/__memory/unique_ptr.h:0: std::__unique_if::__unique_single std::make_unique[abi:v15000]&, std::shared_ptr const&, DB::SelectQueryOptions const&>(std::shared_ptr&, std::shared_ptr const&, DB::SelectQueryOptions const&) @ 0x000000002e5b0821 E 9. ./contrib/llvm-project/libcxx/include/__functional/function.h:0: ? @ 0x000000002e46175d E 10. ./build_docker/./src/Interpreters/executeQuery.cpp:0: DB::executeQueryImpl(char const*, char const*, std::shared_ptr, DB::QueryFlags, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x000000002f1e6e0a E 11. ./build_docker/./src/Interpreters/executeQuery.cpp:1376: DB::executeQuery(String const&, std::shared_ptr, DB::QueryFlags, DB::QueryProcessingStage::Enum) @ 0x000000002f1dde8a E 12. ./contrib/llvm-project/libcxx/include/__memory/shared_ptr.h:612: DB::TCPHandler::runImpl() @ 0x00000000326e9c5d E 13. ./build_docker/./src/Server/TCPHandler.cpp:2341: DB::TCPHandler::run() @ 0x000000003272e6b1 E 14. ./build_docker/./base/poco/Net/src/TCPServerConnection.cpp:57: Poco::Net::TCPServerConnection::start() @ 0x000000003a2162af E 15. ./contrib/llvm-project/libcxx/include/__memory/unique_ptr.h:48: Poco::Net::TCPServerDispatcher::run() @ 0x000000003a216f57 E 16. ./build_docker/./base/poco/Foundation/src/ThreadPool.cpp:0: Poco::PooledThread::run() @ 0x000000003a623f3c E 17. ./base/poco/Foundation/include/Poco/SharedPtr.h:231: Poco::ThreadImpl::runnableEntry(void*) @ 0x000000003a61cf28 E 18. asan_thread_start(void*) @ 0x000000000a7b049b E 19. ? @ 0x00007f5b28be6ac3 E 20. ? @ 0x00007f5b28c78850 E . (UNKNOWN_TABLE) E (query: select * from `test_database.postgresql_replica_0` order by key;) helpers/client.py:239: QueryRuntimeException ---------------------------- Captured stdout setup ----------------------------- PostgreSQL is available - running test ----------------------------- Captured stdout call ----------------------------- Query: CREATE TABLE IF NOT EXISTS "postgresql_replica_0" ( key Integer NOT NULL, value Integer, PRIMARY KEY(key)) Checking table postgresql_replica_0 exists in test_database query INSERT INTO postgresql_replica_{} select i, i from generate_series(0, 10000) as t(i); query DELETE FROM postgresql_replica_{} WHERE (value*value) % 3 = 0; query UPDATE postgresql_replica_{} SET value = value - 125 WHERE key % 2 = 0; query UPDATE postgresql_replica_{} SET key=key+20000 WHERE key%2=0 query INSERT INTO postgresql_replica_{} select i, i from generate_series(40000, 50000) as t(i); query DELETE FROM postgresql_replica_{} WHERE key % 10 = 0; query UPDATE postgresql_replica_{} SET value = value + 101 WHERE key % 2 = 1; query UPDATE postgresql_replica_{} SET key=key+80000 WHERE key%2=1 query DELETE FROM postgresql_replica_{} WHERE value % 2 = 0; query UPDATE postgresql_replica_{} SET value = value + 2000 WHERE key % 5 = 0; query INSERT INTO postgresql_replica_{} select i, i from generate_series(200000, 250000) as t(i); query DELETE FROM postgresql_replica_{} WHERE value % 3 = 0; query UPDATE postgresql_replica_{} SET value = value * 2 WHERE key % 3 = 0; query UPDATE postgresql_replica_{} SET key=key+500000 WHERE key%2=1 query INSERT INTO postgresql_replica_{} select i, i from generate_series(1000000, 1050000) as t(i); query DELETE FROM postgresql_replica_{} WHERE value % 9 = 2; query UPDATE postgresql_replica_{} SET key=key+10000000 query UPDATE postgresql_replica_{} SET value = value + 2 WHERE key % 3 = 1; query DELETE FROM postgresql_replica_{} WHERE value%5 = 0; Checking table postgresql_replica_0 exists in test_database Checking table is synchronized: test_database.postgresql_replica_0 ----------------------------- Captured stderr call ----------------------------- Executing query DROP DATABASE IF EXISTS `test_database` on instance Executing query CREATE DATABASE `test_database` ENGINE = MaterializedPostgreSQL('172.16.4.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') on instance Executing query SHOW DATABASES on instance Executing query SHOW TABLES FROM `test_database` on instance Executing query select count() from test_database.postgresql_replica_0 on instance Executing query SHOW TABLES FROM `test_database` on instance Executing query select * from `postgres_database`.`postgresql_replica_0` order by key; on instance Executing query select * from `test_database.postgresql_replica_0` order by key; on instance ------------------------------ Captured log call ------------------------------- 2025-06-04 01:16:25 [ 520 ] DEBUG : Executing query DROP DATABASE IF EXISTS `test_database` on instance (cluster.py:3455, query) 2025-06-04 01:16:25 [ 520 ] DEBUG : Executing query CREATE DATABASE `test_database` ENGINE = MaterializedPostgreSQL('172.16.4.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') on instance (cluster.py:3455, query) 2025-06-04 01:16:25 [ 520 ] DEBUG : Executing query SHOW DATABASES on instance (cluster.py:3455, query) 2025-06-04 01:16:25 [ 520 ] DEBUG : Executing query SHOW TABLES FROM `test_database` on instance (cluster.py:3455, query) 2025-06-04 01:16:31 [ 520 ] DEBUG : Executing query select count() from test_database.postgresql_replica_0 on instance (cluster.py:3455, query) 2025-06-04 01:16:32 [ 520 ] DEBUG : Executing query SHOW TABLES FROM `test_database` on instance (cluster.py:3455, query) 2025-06-04 01:16:32 [ 520 ] DEBUG : Executing query select * from `postgres_database`.`postgresql_replica_0` order by key; on instance (cluster.py:3455, query) 2025-06-04 01:16:32 [ 520 ] DEBUG : Executing query select * from `test_database.postgresql_replica_0` order by key; on instance (cluster.py:3455, query) --------------------------- Captured stderr teardown --------------------------- Executing query DROP DATABASE IF EXISTS `test_database` SYNC on instance Executing query DROP DATABASE IF EXISTS "postgres_database" on instance Executing query DROP DATABASE IF EXISTS "postgres_database" on instance Executing query CREATE DATABASE "postgres_database" ENGINE = PostgreSQL('172.16.4.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') on instance ---------------------------- Captured log teardown ----------------------------- 2025-06-04 01:16:32 [ 520 ] DEBUG : Executing query DROP DATABASE IF EXISTS `test_database` SYNC on instance (cluster.py:3455, query) 2025-06-04 01:16:33 [ 520 ] DEBUG : Executing query DROP DATABASE IF EXISTS "postgres_database" on instance (cluster.py:3455, query) 2025-06-04 01:16:33 [ 520 ] DEBUG : Executing query DROP DATABASE IF EXISTS "postgres_database" on instance (cluster.py:3455, query) 2025-06-04 01:16:33 [ 520 ] DEBUG : Executing query CREATE DATABASE "postgres_database" ENGINE = PostgreSQL('172.16.4.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') on instance (cluster.py:3455, query) __________________________ test_table_schema_changes ___________________________ [gw3] linux -- Python 3.10.12 /usr/bin/python3 started_cluster = def test_table_schema_changes(started_cluster): NUM_TABLES = 5 for i in range(NUM_TABLES): pg_manager.create_postgres_table( f"postgresql_replica_{i}", template=postgres_table_template_2 ) instance.query( f"INSERT INTO postgres_database.postgresql_replica_{i} SELECT number, {i}, {i}, {i} from numbers(25)" ) pg_manager.create_materialized_db( ip=started_cluster.postgres_ip, port=started_cluster.postgres_port, ) for i in range(NUM_TABLES): instance.query( f"INSERT INTO postgres_database.postgresql_replica_{i} SELECT 25 + number, {i}, {i}, {i} from numbers(25)" ) > check_several_tables_are_synchronized(instance, NUM_TABLES) test_postgresql_replica_database_engine_1/test.py:371: _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ helpers/postgres_utility.py:419: in check_several_tables_are_synchronized check_tables_are_synchronized( helpers/postgres_utility.py:392: in check_tables_are_synchronized result = instance.query(result_query) helpers/cluster.py:3456: in query return self.client.query( helpers/client.py:36: in wrap return func(self, *args, **kwargs) helpers/client.py:74: in query ).get_answer() _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ self = def get_answer(self): self.process.wait(timeout=DEFAULT_QUERY_TIMEOUT) self.stdout_file.seek(0) self.stderr_file.seek(0) stdout = self.stdout_file.read().decode("utf-8", errors="replace") stderr = self.stderr_file.read().decode("utf-8", errors="replace") if ( self.timer is not None and not self.process_finished_before_timeout and not self.ignore_error ): logging.debug(f"Timed out. Last stdout:{stdout}, stderr:{stderr}") raise QueryTimeoutExceedException("Client timed out!") if ( self.process.returncode != 0 or self.remove_trash_from_stderr(stderr) ) and not self.ignore_error: > raise QueryRuntimeException( "Client failed! Return code: {}, stderr: {}".format( self.process.returncode, stderr ), self.process.returncode, stderr, ) E helpers.client.QueryRuntimeException: Client failed! Return code: 60, stderr: Received exception from server (version 24.3.18): E Code: 60. DB::Exception: Received from 172.16.4.3:9000. DB::Exception: Unknown table expression identifier 'test_database.postgresql_replica_0' in scope SELECT * FROM `test_database.postgresql_replica_0` ORDER BY key ASC. Stack trace: E E 0. ./contrib/llvm-project/libcxx/include/exception:141: Poco::Exception::Exception(String const&, int) @ 0x000000003a50df73 E 1. ./build_docker/./src/Common/Exception.cpp:96: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000001cb3f630 E 2. DB::Exception::Exception(int, FormatStringHelperImpl::type, std::type_identity::type>, String const&, String&&) @ 0x000000000c5b9b76 E 3. ./build_docker/./src/Analyzer/Passes/QueryAnalysisPass.cpp:6971: DB::(anonymous namespace)::QueryAnalyzer::resolveQuery(std::shared_ptr const&, DB::(anonymous namespace)::IdentifierResolveScope&) @ 0x000000002db7d229 E 4. ./build_docker/./src/Analyzer/Passes/QueryAnalysisPass.cpp:0: DB::QueryAnalysisPass::run(std::shared_ptr&, std::shared_ptr) @ 0x000000002db6e577 E 5. ./build_docker/./src/Analyzer/QueryTreePassManager.cpp:0: DB::QueryTreePassManager::run(std::shared_ptr) @ 0x000000002db6562e E 6. ./build_docker/./src/Interpreters/InterpreterSelectQueryAnalyzer.cpp:0: DB::(anonymous namespace)::buildQueryTreeAndRunPasses(std::shared_ptr const&, DB::SelectQueryOptions const&, std::shared_ptr const&, std::shared_ptr const&) @ 0x000000002e5acbd6 E 7. ./build_docker/./src/Interpreters/InterpreterSelectQueryAnalyzer.cpp:160: DB::InterpreterSelectQueryAnalyzer::InterpreterSelectQueryAnalyzer(std::shared_ptr const&, std::shared_ptr const&, DB::SelectQueryOptions const&, std::vector> const&) @ 0x000000002e5a56f4 E 8. ./contrib/llvm-project/libcxx/include/__memory/unique_ptr.h:0: std::__unique_if::__unique_single std::make_unique[abi:v15000]&, std::shared_ptr const&, DB::SelectQueryOptions const&>(std::shared_ptr&, std::shared_ptr const&, DB::SelectQueryOptions const&) @ 0x000000002e5b0821 E 9. ./contrib/llvm-project/libcxx/include/__functional/function.h:0: ? @ 0x000000002e46175d E 10. ./build_docker/./src/Interpreters/executeQuery.cpp:0: DB::executeQueryImpl(char const*, char const*, std::shared_ptr, DB::QueryFlags, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x000000002f1e6e0a E 11. ./build_docker/./src/Interpreters/executeQuery.cpp:1376: DB::executeQuery(String const&, std::shared_ptr, DB::QueryFlags, DB::QueryProcessingStage::Enum) @ 0x000000002f1dde8a E 12. ./contrib/llvm-project/libcxx/include/__memory/shared_ptr.h:612: DB::TCPHandler::runImpl() @ 0x00000000326e9c5d E 13. ./build_docker/./src/Server/TCPHandler.cpp:2341: DB::TCPHandler::run() @ 0x000000003272e6b1 E 14. ./build_docker/./base/poco/Net/src/TCPServerConnection.cpp:57: Poco::Net::TCPServerConnection::start() @ 0x000000003a2162af E 15. ./contrib/llvm-project/libcxx/include/__memory/unique_ptr.h:48: Poco::Net::TCPServerDispatcher::run() @ 0x000000003a216f57 E 16. ./build_docker/./base/poco/Foundation/src/ThreadPool.cpp:0: Poco::PooledThread::run() @ 0x000000003a623f3c E 17. ./base/poco/Foundation/include/Poco/SharedPtr.h:231: Poco::ThreadImpl::runnableEntry(void*) @ 0x000000003a61cf28 E 18. asan_thread_start(void*) @ 0x000000000a7b049b E 19. ? @ 0x00007f5b28be6ac3 E 20. ? @ 0x00007f5b28c78850 E . (UNKNOWN_TABLE) E (query: select * from `test_database.postgresql_replica_0` order by key;) helpers/client.py:239: QueryRuntimeException ---------------------------- Captured stdout setup ----------------------------- PostgreSQL is available - running test ----------------------------- Captured stdout call ----------------------------- Query: CREATE TABLE IF NOT EXISTS "postgresql_replica_0" ( key Integer NOT NULL, value1 Integer, value2 Integer, value3 Integer, PRIMARY KEY(key)) Query: CREATE TABLE IF NOT EXISTS "postgresql_replica_1" ( key Integer NOT NULL, value1 Integer, value2 Integer, value3 Integer, PRIMARY KEY(key)) Query: CREATE TABLE IF NOT EXISTS "postgresql_replica_2" ( key Integer NOT NULL, value1 Integer, value2 Integer, value3 Integer, PRIMARY KEY(key)) Query: CREATE TABLE IF NOT EXISTS "postgresql_replica_3" ( key Integer NOT NULL, value1 Integer, value2 Integer, value3 Integer, PRIMARY KEY(key)) Query: CREATE TABLE IF NOT EXISTS "postgresql_replica_4" ( key Integer NOT NULL, value1 Integer, value2 Integer, value3 Integer, PRIMARY KEY(key)) Checking table postgresql_replica_0 exists in test_database Checking table is synchronized: test_database.postgresql_replica_0 ----------------------------- Captured stderr call ----------------------------- Executing query INSERT INTO postgres_database.postgresql_replica_0 SELECT number, 0, 0, 0 from numbers(25) on instance Executing query INSERT INTO postgres_database.postgresql_replica_1 SELECT number, 1, 1, 1 from numbers(25) on instance Executing query INSERT INTO postgres_database.postgresql_replica_2 SELECT number, 2, 2, 2 from numbers(25) on instance Executing query INSERT INTO postgres_database.postgresql_replica_3 SELECT number, 3, 3, 3 from numbers(25) on instance Executing query INSERT INTO postgres_database.postgresql_replica_4 SELECT number, 4, 4, 4 from numbers(25) on instance Executing query DROP DATABASE IF EXISTS `test_database` on instance Executing query CREATE DATABASE `test_database` ENGINE = MaterializedPostgreSQL('172.16.4.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') on instance Executing query SHOW DATABASES on instance Executing query INSERT INTO postgres_database.postgresql_replica_0 SELECT 25 + number, 0, 0, 0 from numbers(25) on instance Executing query INSERT INTO postgres_database.postgresql_replica_1 SELECT 25 + number, 1, 1, 1 from numbers(25) on instance Executing query INSERT INTO postgres_database.postgresql_replica_2 SELECT 25 + number, 2, 2, 2 from numbers(25) on instance Executing query INSERT INTO postgres_database.postgresql_replica_3 SELECT 25 + number, 3, 3, 3 from numbers(25) on instance Executing query INSERT INTO postgres_database.postgresql_replica_4 SELECT 25 + number, 4, 4, 4 from numbers(25) on instance Executing query SHOW TABLES FROM `test_database` on instance Executing query select * from `postgres_database`.`postgresql_replica_0` order by key; on instance Executing query select * from `test_database.postgresql_replica_0` order by key; on instance ------------------------------ Captured log call ------------------------------- 2025-06-04 01:16:33 [ 520 ] DEBUG : Executing query INSERT INTO postgres_database.postgresql_replica_0 SELECT number, 0, 0, 0 from numbers(25) on instance (cluster.py:3455, query) 2025-06-04 01:16:34 [ 520 ] DEBUG : Executing query INSERT INTO postgres_database.postgresql_replica_1 SELECT number, 1, 1, 1 from numbers(25) on instance (cluster.py:3455, query) 2025-06-04 01:16:34 [ 520 ] DEBUG : Executing query INSERT INTO postgres_database.postgresql_replica_2 SELECT number, 2, 2, 2 from numbers(25) on instance (cluster.py:3455, query) 2025-06-04 01:16:34 [ 520 ] DEBUG : Executing query INSERT INTO postgres_database.postgresql_replica_3 SELECT number, 3, 3, 3 from numbers(25) on instance (cluster.py:3455, query) 2025-06-04 01:16:34 [ 520 ] DEBUG : Executing query INSERT INTO postgres_database.postgresql_replica_4 SELECT number, 4, 4, 4 from numbers(25) on instance (cluster.py:3455, query) 2025-06-04 01:16:34 [ 520 ] DEBUG : Executing query DROP DATABASE IF EXISTS `test_database` on instance (cluster.py:3455, query) 2025-06-04 01:16:35 [ 520 ] DEBUG : Executing query CREATE DATABASE `test_database` ENGINE = MaterializedPostgreSQL('172.16.4.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') on instance (cluster.py:3455, query) 2025-06-04 01:16:35 [ 520 ] DEBUG : Executing query SHOW DATABASES on instance (cluster.py:3455, query) 2025-06-04 01:16:35 [ 520 ] DEBUG : Executing query INSERT INTO postgres_database.postgresql_replica_0 SELECT 25 + number, 0, 0, 0 from numbers(25) on instance (cluster.py:3455, query) 2025-06-04 01:16:35 [ 520 ] DEBUG : Executing query INSERT INTO postgres_database.postgresql_replica_1 SELECT 25 + number, 1, 1, 1 from numbers(25) on instance (cluster.py:3455, query) 2025-06-04 01:16:35 [ 520 ] DEBUG : Executing query INSERT INTO postgres_database.postgresql_replica_2 SELECT 25 + number, 2, 2, 2 from numbers(25) on instance (cluster.py:3455, query) 2025-06-04 01:16:36 [ 520 ] DEBUG : Executing query INSERT INTO postgres_database.postgresql_replica_3 SELECT 25 + number, 3, 3, 3 from numbers(25) on instance (cluster.py:3455, query) 2025-06-04 01:16:36 [ 520 ] DEBUG : Executing query INSERT INTO postgres_database.postgresql_replica_4 SELECT 25 + number, 4, 4, 4 from numbers(25) on instance (cluster.py:3455, query) 2025-06-04 01:16:36 [ 520 ] DEBUG : Executing query SHOW TABLES FROM `test_database` on instance (cluster.py:3455, query) 2025-06-04 01:16:37 [ 520 ] DEBUG : Executing query select * from `postgres_database`.`postgresql_replica_0` order by key; on instance (cluster.py:3455, query) 2025-06-04 01:16:37 [ 520 ] DEBUG : Executing query select * from `test_database.postgresql_replica_0` order by key; on instance (cluster.py:3455, query) --------------------------- Captured stderr teardown --------------------------- Executing query DROP DATABASE IF EXISTS `test_database` SYNC on instance Executing query DROP DATABASE IF EXISTS "postgres_database" on instance Executing query DROP DATABASE IF EXISTS "postgres_database" on instance Executing query CREATE DATABASE "postgres_database" ENGINE = PostgreSQL('172.16.4.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') on instance ---------------------------- Captured log teardown ----------------------------- 2025-06-04 01:16:37 [ 520 ] DEBUG : Executing query DROP DATABASE IF EXISTS `test_database` SYNC on instance (cluster.py:3455, query) 2025-06-04 01:16:37 [ 520 ] DEBUG : Executing query DROP DATABASE IF EXISTS "postgres_database" on instance (cluster.py:3455, query) 2025-06-04 01:16:38 [ 520 ] DEBUG : Executing query DROP DATABASE IF EXISTS "postgres_database" on instance (cluster.py:3455, query) 2025-06-04 01:16:38 [ 520 ] DEBUG : Executing query CREATE DATABASE "postgres_database" ENGINE = PostgreSQL('172.16.4.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') on instance (cluster.py:3455, query) ___________________________ test_user_managed_slots ____________________________ [gw3] linux -- Python 3.10.12 /usr/bin/python3 started_cluster = def test_user_managed_slots(started_cluster): slot_name = "user_slot" table_name = "test_table" pg_manager.create_and_fill_postgres_table(table_name) replication_connection = get_postgres_conn( ip=started_cluster.postgres_ip, port=started_cluster.postgres_port, database=True, replication=True, auto_commit=True, ) snapshot = create_replication_slot(replication_connection, slot_name=slot_name) pg_manager.create_materialized_db( ip=started_cluster.postgres_ip, port=started_cluster.postgres_port, settings=[ f"materialized_postgresql_replication_slot = '{slot_name}'", f"materialized_postgresql_snapshot = '{snapshot}'", ], ) > check_tables_are_synchronized(instance, table_name) test_postgresql_replica_database_engine_1/test.py:865: _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ helpers/postgres_utility.py:392: in check_tables_are_synchronized result = instance.query(result_query) helpers/cluster.py:3456: in query return self.client.query( helpers/client.py:36: in wrap return func(self, *args, **kwargs) helpers/client.py:74: in query ).get_answer() _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ self = def get_answer(self): self.process.wait(timeout=DEFAULT_QUERY_TIMEOUT) self.stdout_file.seek(0) self.stderr_file.seek(0) stdout = self.stdout_file.read().decode("utf-8", errors="replace") stderr = self.stderr_file.read().decode("utf-8", errors="replace") if ( self.timer is not None and not self.process_finished_before_timeout and not self.ignore_error ): logging.debug(f"Timed out. Last stdout:{stdout}, stderr:{stderr}") raise QueryTimeoutExceedException("Client timed out!") if ( self.process.returncode != 0 or self.remove_trash_from_stderr(stderr) ) and not self.ignore_error: > raise QueryRuntimeException( "Client failed! Return code: {}, stderr: {}".format( self.process.returncode, stderr ), self.process.returncode, stderr, ) E helpers.client.QueryRuntimeException: Client failed! Return code: 60, stderr: Received exception from server (version 24.3.18): E Code: 60. DB::Exception: Received from 172.16.4.3:9000. DB::Exception: Unknown table expression identifier 'test_database.test_table' in scope SELECT * FROM `test_database.test_table` ORDER BY key ASC. Stack trace: E E 0. ./contrib/llvm-project/libcxx/include/exception:141: Poco::Exception::Exception(String const&, int) @ 0x000000003a50df73 E 1. ./build_docker/./src/Common/Exception.cpp:96: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000001cb3f630 E 2. DB::Exception::Exception(int, FormatStringHelperImpl::type, std::type_identity::type>, String const&, String&&) @ 0x000000000c5b9b76 E 3. ./build_docker/./src/Analyzer/Passes/QueryAnalysisPass.cpp:6971: DB::(anonymous namespace)::QueryAnalyzer::resolveQuery(std::shared_ptr const&, DB::(anonymous namespace)::IdentifierResolveScope&) @ 0x000000002db7d229 E 4. ./build_docker/./src/Analyzer/Passes/QueryAnalysisPass.cpp:0: DB::QueryAnalysisPass::run(std::shared_ptr&, std::shared_ptr) @ 0x000000002db6e577 E 5. ./build_docker/./src/Analyzer/QueryTreePassManager.cpp:0: DB::QueryTreePassManager::run(std::shared_ptr) @ 0x000000002db6562e E 6. ./build_docker/./src/Interpreters/InterpreterSelectQueryAnalyzer.cpp:0: DB::(anonymous namespace)::buildQueryTreeAndRunPasses(std::shared_ptr const&, DB::SelectQueryOptions const&, std::shared_ptr const&, std::shared_ptr const&) @ 0x000000002e5acbd6 E 7. ./build_docker/./src/Interpreters/InterpreterSelectQueryAnalyzer.cpp:160: DB::InterpreterSelectQueryAnalyzer::InterpreterSelectQueryAnalyzer(std::shared_ptr const&, std::shared_ptr const&, DB::SelectQueryOptions const&, std::vector> const&) @ 0x000000002e5a56f4 E 8. ./contrib/llvm-project/libcxx/include/__memory/unique_ptr.h:0: std::__unique_if::__unique_single std::make_unique[abi:v15000]&, std::shared_ptr const&, DB::SelectQueryOptions const&>(std::shared_ptr&, std::shared_ptr const&, DB::SelectQueryOptions const&) @ 0x000000002e5b0821 E 9. ./contrib/llvm-project/libcxx/include/__functional/function.h:0: ? @ 0x000000002e46175d E 10. ./build_docker/./src/Interpreters/executeQuery.cpp:0: DB::executeQueryImpl(char const*, char const*, std::shared_ptr, DB::QueryFlags, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x000000002f1e6e0a E 11. ./build_docker/./src/Interpreters/executeQuery.cpp:1376: DB::executeQuery(String const&, std::shared_ptr, DB::QueryFlags, DB::QueryProcessingStage::Enum) @ 0x000000002f1dde8a E 12. ./contrib/llvm-project/libcxx/include/__memory/shared_ptr.h:612: DB::TCPHandler::runImpl() @ 0x00000000326e9c5d E 13. ./build_docker/./src/Server/TCPHandler.cpp:2341: DB::TCPHandler::run() @ 0x000000003272e6b1 E 14. ./build_docker/./base/poco/Net/src/TCPServerConnection.cpp:57: Poco::Net::TCPServerConnection::start() @ 0x000000003a2162af E 15. ./contrib/llvm-project/libcxx/include/__memory/unique_ptr.h:48: Poco::Net::TCPServerDispatcher::run() @ 0x000000003a216f57 E 16. ./build_docker/./base/poco/Foundation/src/ThreadPool.cpp:0: Poco::PooledThread::run() @ 0x000000003a623f3c E 17. ./base/poco/Foundation/include/Poco/SharedPtr.h:231: Poco::ThreadImpl::runnableEntry(void*) @ 0x000000003a61cf28 E 18. asan_thread_start(void*) @ 0x000000000a7b049b E 19. ? @ 0x00007f5b28be6ac3 E 20. ? @ 0x00007f5b28c78850 E . (UNKNOWN_TABLE) E (query: select * from `test_database.test_table` order by key;) helpers/client.py:239: QueryRuntimeException ---------------------------- Captured stdout setup ----------------------------- PostgreSQL is available - running test ----------------------------- Captured stdout call ----------------------------- Query: CREATE TABLE IF NOT EXISTS "test_table" ( key Integer NOT NULL, value Integer, PRIMARY KEY(key)) user_slot 0/82C2058 000000DA-00000002-1 Checking table test_table exists in test_database Checking table is synchronized: test_database.test_table ----------------------------- Captured stderr call ----------------------------- Executing query INSERT INTO `postgres_database`.`test_table` SELECT number, number from numbers(50) on instance Executing query DROP DATABASE IF EXISTS `test_database` on instance Executing query CREATE DATABASE `test_database` ENGINE = MaterializedPostgreSQL('172.16.4.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') SETTINGS materialized_postgresql_replication_slot = 'user_slot', materialized_postgresql_snapshot = '000000DA-00000002-1' on instance Executing query SHOW DATABASES on instance Executing query SHOW TABLES FROM `test_database` on instance Executing query select * from `postgres_database`.`test_table` order by key; on instance Executing query select * from `test_database.test_table` order by key; on instance ------------------------------ Captured log call ------------------------------- 2025-06-04 01:16:38 [ 520 ] DEBUG : Executing query INSERT INTO `postgres_database`.`test_table` SELECT number, number from numbers(50) on instance (cluster.py:3455, query) 2025-06-04 01:16:38 [ 520 ] DEBUG : Executing query DROP DATABASE IF EXISTS `test_database` on instance (cluster.py:3455, query) 2025-06-04 01:16:39 [ 520 ] DEBUG : Executing query CREATE DATABASE `test_database` ENGINE = MaterializedPostgreSQL('172.16.4.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') SETTINGS materialized_postgresql_replication_slot = 'user_slot', materialized_postgresql_snapshot = '000000DA-00000002-1' on instance (cluster.py:3455, query) 2025-06-04 01:16:39 [ 520 ] DEBUG : Executing query SHOW DATABASES on instance (cluster.py:3455, query) 2025-06-04 01:16:39 [ 520 ] DEBUG : Executing query SHOW TABLES FROM `test_database` on instance (cluster.py:3455, query) 2025-06-04 01:16:40 [ 520 ] DEBUG : Executing query select * from `postgres_database`.`test_table` order by key; on instance (cluster.py:3455, query) 2025-06-04 01:16:40 [ 520 ] DEBUG : Executing query select * from `test_database.test_table` order by key; on instance (cluster.py:3455, query) --------------------------- Captured stderr teardown --------------------------- Executing query DROP DATABASE IF EXISTS `test_database` SYNC on instance Executing query DROP DATABASE IF EXISTS "postgres_database" on instance Executing query DROP DATABASE IF EXISTS "postgres_database" on instance Executing query CREATE DATABASE "postgres_database" ENGINE = PostgreSQL('172.16.4.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') on instance ---------------------------- Captured log teardown ----------------------------- 2025-06-04 01:16:40 [ 520 ] DEBUG : Executing query DROP DATABASE IF EXISTS `test_database` SYNC on instance (cluster.py:3455, query) 2025-06-04 01:16:40 [ 520 ] DEBUG : Executing query DROP DATABASE IF EXISTS "postgres_database" on instance (cluster.py:3455, query) 2025-06-04 01:16:41 [ 520 ] DEBUG : Executing query DROP DATABASE IF EXISTS "postgres_database" on instance (cluster.py:3455, query) 2025-06-04 01:16:41 [ 520 ] DEBUG : Executing query CREATE DATABASE "postgres_database" ENGINE = PostgreSQL('172.16.4.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') on instance (cluster.py:3455, query) _____________________________ test_virtual_columns _____________________________ [gw3] linux -- Python 3.10.12 /usr/bin/python3 started_cluster = def test_virtual_columns(started_cluster): conn = get_postgres_conn( ip=started_cluster.postgres_ip, port=started_cluster.postgres_port, database=True, ) cursor = conn.cursor() table_name = "postgresql_replica_0" create_postgres_table(cursor, table_name) pg_manager.create_materialized_db( ip=started_cluster.postgres_ip, port=started_cluster.postgres_port, ) assert_nested_table_is_created(instance, table_name) instance.query( f"INSERT INTO postgres_database.{table_name} SELECT number, number from numbers(10)" ) > check_tables_are_synchronized(instance, table_name) test_postgresql_replica_database_engine_1/test.py:553: _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ helpers/postgres_utility.py:392: in check_tables_are_synchronized result = instance.query(result_query) helpers/cluster.py:3456: in query return self.client.query( helpers/client.py:36: in wrap return func(self, *args, **kwargs) helpers/client.py:74: in query ).get_answer() _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ self = def get_answer(self): self.process.wait(timeout=DEFAULT_QUERY_TIMEOUT) self.stdout_file.seek(0) self.stderr_file.seek(0) stdout = self.stdout_file.read().decode("utf-8", errors="replace") stderr = self.stderr_file.read().decode("utf-8", errors="replace") if ( self.timer is not None and not self.process_finished_before_timeout and not self.ignore_error ): logging.debug(f"Timed out. Last stdout:{stdout}, stderr:{stderr}") raise QueryTimeoutExceedException("Client timed out!") if ( self.process.returncode != 0 or self.remove_trash_from_stderr(stderr) ) and not self.ignore_error: > raise QueryRuntimeException( "Client failed! Return code: {}, stderr: {}".format( self.process.returncode, stderr ), self.process.returncode, stderr, ) E helpers.client.QueryRuntimeException: Client failed! Return code: 60, stderr: Received exception from server (version 24.3.18): E Code: 60. DB::Exception: Received from 172.16.4.3:9000. DB::Exception: Unknown table expression identifier 'test_database.postgresql_replica_0' in scope SELECT * FROM `test_database.postgresql_replica_0` ORDER BY key ASC. Stack trace: E E 0. ./contrib/llvm-project/libcxx/include/exception:141: Poco::Exception::Exception(String const&, int) @ 0x000000003a50df73 E 1. ./build_docker/./src/Common/Exception.cpp:96: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000001cb3f630 E 2. DB::Exception::Exception(int, FormatStringHelperImpl::type, std::type_identity::type>, String const&, String&&) @ 0x000000000c5b9b76 E 3. ./build_docker/./src/Analyzer/Passes/QueryAnalysisPass.cpp:6971: DB::(anonymous namespace)::QueryAnalyzer::resolveQuery(std::shared_ptr const&, DB::(anonymous namespace)::IdentifierResolveScope&) @ 0x000000002db7d229 E 4. ./build_docker/./src/Analyzer/Passes/QueryAnalysisPass.cpp:0: DB::QueryAnalysisPass::run(std::shared_ptr&, std::shared_ptr) @ 0x000000002db6e577 E 5. ./build_docker/./src/Analyzer/QueryTreePassManager.cpp:0: DB::QueryTreePassManager::run(std::shared_ptr) @ 0x000000002db6562e E 6. ./build_docker/./src/Interpreters/InterpreterSelectQueryAnalyzer.cpp:0: DB::(anonymous namespace)::buildQueryTreeAndRunPasses(std::shared_ptr const&, DB::SelectQueryOptions const&, std::shared_ptr const&, std::shared_ptr const&) @ 0x000000002e5acbd6 E 7. ./build_docker/./src/Interpreters/InterpreterSelectQueryAnalyzer.cpp:160: DB::InterpreterSelectQueryAnalyzer::InterpreterSelectQueryAnalyzer(std::shared_ptr const&, std::shared_ptr const&, DB::SelectQueryOptions const&, std::vector> const&) @ 0x000000002e5a56f4 E 8. ./contrib/llvm-project/libcxx/include/__memory/unique_ptr.h:0: std::__unique_if::__unique_single std::make_unique[abi:v15000]&, std::shared_ptr const&, DB::SelectQueryOptions const&>(std::shared_ptr&, std::shared_ptr const&, DB::SelectQueryOptions const&) @ 0x000000002e5b0821 E 9. ./contrib/llvm-project/libcxx/include/__functional/function.h:0: ? @ 0x000000002e46175d E 10. ./build_docker/./src/Interpreters/executeQuery.cpp:0: DB::executeQueryImpl(char const*, char const*, std::shared_ptr, DB::QueryFlags, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x000000002f1e6e0a E 11. ./build_docker/./src/Interpreters/executeQuery.cpp:1376: DB::executeQuery(String const&, std::shared_ptr, DB::QueryFlags, DB::QueryProcessingStage::Enum) @ 0x000000002f1dde8a E 12. ./contrib/llvm-project/libcxx/include/__memory/shared_ptr.h:612: DB::TCPHandler::runImpl() @ 0x00000000326e9c5d E 13. ./build_docker/./src/Server/TCPHandler.cpp:2341: DB::TCPHandler::run() @ 0x000000003272e6b1 E 14. ./build_docker/./base/poco/Net/src/TCPServerConnection.cpp:57: Poco::Net::TCPServerConnection::start() @ 0x000000003a2162af E 15. ./contrib/llvm-project/libcxx/include/__memory/unique_ptr.h:48: Poco::Net::TCPServerDispatcher::run() @ 0x000000003a216f57 E 16. ./build_docker/./base/poco/Foundation/src/ThreadPool.cpp:0: Poco::PooledThread::run() @ 0x000000003a623f3c E 17. ./base/poco/Foundation/include/Poco/SharedPtr.h:231: Poco::ThreadImpl::runnableEntry(void*) @ 0x000000003a61cf28 E 18. asan_thread_start(void*) @ 0x000000000a7b049b E 19. ? @ 0x00007f5b28be6ac3 E 20. ? @ 0x00007f5b28c78850 E . (UNKNOWN_TABLE) E (query: select * from `test_database.postgresql_replica_0` order by key;) helpers/client.py:239: QueryRuntimeException ---------------------------- Captured stdout setup ----------------------------- PostgreSQL is available - running test ----------------------------- Captured stdout call ----------------------------- Query: CREATE TABLE IF NOT EXISTS "postgresql_replica_0" ( key Integer NOT NULL, value Integer, PRIMARY KEY(key)) Checking table postgresql_replica_0 exists in test_database Checking table postgresql_replica_0 exists in test_database Checking table is synchronized: test_database.postgresql_replica_0 ----------------------------- Captured stderr call ----------------------------- Executing query DROP DATABASE IF EXISTS `test_database` on instance Executing query CREATE DATABASE `test_database` ENGINE = MaterializedPostgreSQL('172.16.4.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') on instance Executing query SHOW DATABASES on instance Executing query SHOW TABLES FROM `test_database` on instance Executing query INSERT INTO postgres_database.postgresql_replica_0 SELECT number, number from numbers(10) on instance Executing query SHOW TABLES FROM `test_database` on instance Executing query select * from `postgres_database`.`postgresql_replica_0` order by key; on instance Executing query select * from `test_database.postgresql_replica_0` order by key; on instance ------------------------------ Captured log call ------------------------------- 2025-06-04 01:16:42 [ 520 ] DEBUG : Executing query DROP DATABASE IF EXISTS `test_database` on instance (cluster.py:3455, query) 2025-06-04 01:16:42 [ 520 ] DEBUG : Executing query CREATE DATABASE `test_database` ENGINE = MaterializedPostgreSQL('172.16.4.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') on instance (cluster.py:3455, query) 2025-06-04 01:16:42 [ 520 ] DEBUG : Executing query SHOW DATABASES on instance (cluster.py:3455, query) 2025-06-04 01:16:42 [ 520 ] DEBUG : Executing query SHOW TABLES FROM `test_database` on instance (cluster.py:3455, query) 2025-06-04 01:16:43 [ 520 ] DEBUG : Executing query INSERT INTO postgres_database.postgresql_replica_0 SELECT number, number from numbers(10) on instance (cluster.py:3455, query) 2025-06-04 01:16:43 [ 520 ] DEBUG : Executing query SHOW TABLES FROM `test_database` on instance (cluster.py:3455, query) 2025-06-04 01:16:43 [ 520 ] DEBUG : Executing query select * from `postgres_database`.`postgresql_replica_0` order by key; on instance (cluster.py:3455, query) 2025-06-04 01:16:44 [ 520 ] DEBUG : Executing query select * from `test_database.postgresql_replica_0` order by key; on instance (cluster.py:3455, query) --------------------------- Captured stderr teardown --------------------------- Executing query DROP DATABASE IF EXISTS `test_database` SYNC on instance Executing query DROP DATABASE IF EXISTS "postgres_database" on instance Executing query DROP DATABASE IF EXISTS "postgres_database" on instance Executing query CREATE DATABASE "postgres_database" ENGINE = PostgreSQL('172.16.4.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') on instance Command:['docker-compose', '--env-file', '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/.env', '--project-name', 'roottestpostgresqlreplicadatabaseengine1', '--file', '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/instance/docker-compose.yml', '--file', '/ClickHouse/tests/integration/helpers/../../../tests/integration/compose/docker_compose_postgres.yml', 'stop', '--timeout', '20'] Stderr:Stopping roottestpostgresqlreplicadatabaseengine1_instance_1 ... Stderr:Stopping roottestpostgresqlreplicadatabaseengine1_postgres1_1 ... Stderr:Stopping roottestpostgresqlreplicadatabaseengine1_instance_1 ... done Stderr:Stopping roottestpostgresqlreplicadatabaseengine1_postgres1_1 ... done Command:['bash', '-c', '[ -f /ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/instance/logs/stderr.log ] && zgrep -aH "==================" /ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/instance/logs/stderr.log* || true'] Command:['docker-compose', '--env-file', '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/.env', '--project-name', 'roottestpostgresqlreplicadatabaseengine1', '--file', '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/instance/docker-compose.yml', '--file', '/ClickHouse/tests/integration/helpers/../../../tests/integration/compose/docker_compose_postgres.yml', 'down', '--volumes'] Stderr:Removing roottestpostgresqlreplicadatabaseengine1_instance_1 ... Stderr:Removing roottestpostgresqlreplicadatabaseengine1_postgres1_1 ... Stderr:Removing roottestpostgresqlreplicadatabaseengine1_postgres1_1 ... done Stderr:Removing roottestpostgresqlreplicadatabaseengine1_instance_1 ... done Stderr:Removing network roottestpostgresqlreplicadatabaseengine1_default Cleanup called Docker networks for project roottestpostgresqlreplicadatabaseengine1 are NETWORK ID NAME DRIVER SCOPE Docker containers for project roottestpostgresqlreplicadatabaseengine1 are CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES Docker volumes for project roottestpostgresqlreplicadatabaseengine1 are DRIVER VOLUME NAME Command:docker container list --all --filter name='^/roottestpostgresqlreplicadatabaseengine1_.*_1$' --format '{{.ID}}:{{.Names}}' Unstopped containers: {} No running containers for project: roottestpostgresqlreplicadatabaseengine1 Trying to prune unused networks... Trying to prune unused images... Command:['docker', 'image', 'prune', '-f'] Stdout:Total reclaimed space: 0B Images pruned Trying to prune unused volumes... Command:['docker volume ls | wc -l'] Stdout:3 ---------------------------- Captured log teardown ----------------------------- 2025-06-04 01:16:44 [ 520 ] DEBUG : Executing query DROP DATABASE IF EXISTS `test_database` SYNC on instance (cluster.py:3455, query) 2025-06-04 01:16:44 [ 520 ] DEBUG : Executing query DROP DATABASE IF EXISTS "postgres_database" on instance (cluster.py:3455, query) 2025-06-04 01:16:45 [ 520 ] DEBUG : Executing query DROP DATABASE IF EXISTS "postgres_database" on instance (cluster.py:3455, query) 2025-06-04 01:16:45 [ 520 ] DEBUG : Executing query CREATE DATABASE "postgres_database" ENGINE = PostgreSQL('172.16.4.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') on instance (cluster.py:3455, query) 2025-06-04 01:16:46 [ 520 ] DEBUG : Command:['docker-compose', '--env-file', '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/.env', '--project-name', 'roottestpostgresqlreplicadatabaseengine1', '--file', '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/instance/docker-compose.yml', '--file', '/ClickHouse/tests/integration/helpers/../../../tests/integration/compose/docker_compose_postgres.yml', 'stop', '--timeout', '20'] (cluster.py:113, run_and_check) 2025-06-04 01:16:47 [ 520 ] DEBUG : Stderr:Stopping roottestpostgresqlreplicadatabaseengine1_instance_1 ... (cluster.py:123, run_and_check) 2025-06-04 01:16:47 [ 520 ] DEBUG : Stderr:Stopping roottestpostgresqlreplicadatabaseengine1_postgres1_1 ... (cluster.py:123, run_and_check) 2025-06-04 01:16:47 [ 520 ] DEBUG : Stderr:Stopping roottestpostgresqlreplicadatabaseengine1_instance_1 ... done (cluster.py:123, run_and_check) 2025-06-04 01:16:47 [ 520 ] DEBUG : Stderr:Stopping roottestpostgresqlreplicadatabaseengine1_postgres1_1 ... done (cluster.py:123, run_and_check) 2025-06-04 01:16:47 [ 520 ] DEBUG : Command:['bash', '-c', '[ -f /ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/instance/logs/stderr.log ] && zgrep -aH "==================" /ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/instance/logs/stderr.log* || true'] (cluster.py:113, run_and_check) 2025-06-04 01:16:47 [ 520 ] DEBUG : Command:['docker-compose', '--env-file', '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/.env', '--project-name', 'roottestpostgresqlreplicadatabaseengine1', '--file', '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/instance/docker-compose.yml', '--file', '/ClickHouse/tests/integration/helpers/../../../tests/integration/compose/docker_compose_postgres.yml', 'down', '--volumes'] (cluster.py:113, run_and_check) 2025-06-04 01:16:48 [ 520 ] DEBUG : Stderr:Removing roottestpostgresqlreplicadatabaseengine1_instance_1 ... (cluster.py:123, run_and_check) 2025-06-04 01:16:48 [ 520 ] DEBUG : Stderr:Removing roottestpostgresqlreplicadatabaseengine1_postgres1_1 ... (cluster.py:123, run_and_check) 2025-06-04 01:16:48 [ 520 ] DEBUG : Stderr:Removing roottestpostgresqlreplicadatabaseengine1_postgres1_1 ... done (cluster.py:123, run_and_check) 2025-06-04 01:16:48 [ 520 ] DEBUG : Stderr:Removing roottestpostgresqlreplicadatabaseengine1_instance_1 ... done (cluster.py:123, run_and_check) 2025-06-04 01:16:48 [ 520 ] DEBUG : Stderr:Removing network roottestpostgresqlreplicadatabaseengine1_default (cluster.py:123, run_and_check) 2025-06-04 01:16:48 [ 520 ] DEBUG : Cleanup called (cluster.py:801, cleanup) 2025-06-04 01:16:48 [ 520 ] DEBUG : Docker networks for project roottestpostgresqlreplicadatabaseengine1 are NETWORK ID NAME DRIVER SCOPE (cluster.py:780, print_all_docker_pieces) 2025-06-04 01:16:48 [ 520 ] DEBUG : Docker containers for project roottestpostgresqlreplicadatabaseengine1 are CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES (cluster.py:788, print_all_docker_pieces) 2025-06-04 01:16:48 [ 520 ] DEBUG : Docker volumes for project roottestpostgresqlreplicadatabaseengine1 are DRIVER VOLUME NAME (cluster.py:796, print_all_docker_pieces) 2025-06-04 01:16:48 [ 520 ] DEBUG : Command:docker container list --all --filter name='^/roottestpostgresqlreplicadatabaseengine1_.*_1$' --format '{{.ID}}:{{.Names}}' (cluster.py:113, run_and_check) 2025-06-04 01:16:48 [ 520 ] DEBUG : Unstopped containers: {} (cluster.py:815, cleanup) 2025-06-04 01:16:48 [ 520 ] DEBUG : No running containers for project: roottestpostgresqlreplicadatabaseengine1 (cluster.py:829, cleanup) 2025-06-04 01:16:48 [ 520 ] DEBUG : Trying to prune unused networks... (cluster.py:835, cleanup) 2025-06-04 01:16:48 [ 520 ] DEBUG : Trying to prune unused images... (cluster.py:851, cleanup) 2025-06-04 01:16:48 [ 520 ] DEBUG : Command:['docker', 'image', 'prune', '-f'] (cluster.py:113, run_and_check) 2025-06-04 01:16:48 [ 520 ] DEBUG : Stdout:Total reclaimed space: 0B (cluster.py:121, run_and_check) 2025-06-04 01:16:48 [ 520 ] DEBUG : Images pruned (cluster.py:854, cleanup) 2025-06-04 01:16:48 [ 520 ] DEBUG : Trying to prune unused volumes... (cluster.py:860, cleanup) 2025-06-04 01:16:48 [ 520 ] DEBUG : Command:['docker volume ls | wc -l'] (cluster.py:113, run_and_check) 2025-06-04 01:16:48 [ 520 ] DEBUG : Stdout:3 (cluster.py:121, run_and_check) =============================== warnings summary =============================== test_s3_with_https/test.py::test_s3_with_https[s3_secure] /usr/local/lib/python3.10/dist-packages/urllib3/connectionpool.py:1099: InsecureRequestWarning: Unverified HTTPS request is being made to host '172.16.8.5'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/latest/advanced-usage.html#tls-warnings warnings.warn( -- Docs: https://docs.pytest.org/en/stable/how-to/capture-warnings.html ============================== slowest durations =============================== 300.72s call test_s3_aws_sdk_has_slightly_unreliable_behaviour/test.py::test_dataloss 48.90s call test_replicated_mutations/test.py::test_mutations_dont_prevent_merges[nodes0] 48.25s call test_replicated_merge_tree_s3_zero_copy/test.py::test_drop_table 47.93s call test_replicated_mutations/test.py::test_mutations_dont_prevent_merges[nodes1] 42.60s setup test_replication_credentials/test.py::test_credentials_and_no_credentials 36.39s setup test_replicated_merge_tree_s3_zero_copy/test.py::test_drop_table 36.35s call test_replicated_merge_tree_compatibility/test.py::test_replicated_merge_tree_defaults_compatibility 34.86s call test_replicated_mutations/test.py::test_mutations 34.69s setup test_s3_zero_copy_ttl/test.py::test_ttl_move_and_s3 33.25s call test_replicated_user_defined_functions/test.py::test_start_without_zookeeper 32.74s setup test_replicated_mutations/test.py::test_mutations 27.43s call test_replicated_user_defined_functions/test.py::test_reload_zookeeper 24.09s teardown test_s3_with_https/test.py::test_s3_with_https[s3_secure_with_proxy] 24.04s teardown test_replicated_merge_tree_s3_zero_copy/test.py::test_s3_check_restore 22.67s teardown test_s3_zero_copy_ttl/test.py::test_ttl_move_and_s3 22.51s teardown test_s3_imds/test_session_token.py::test_credentials_from_metadata 22.24s teardown test_s3_aws_sdk_has_slightly_unreliable_behaviour/test.py::test_dataloss 21.82s setup test_replicating_constants/test.py::test_different_versions 21.81s setup test_replicated_users/test.py::test_create_and_delete_replicated[QUOTA] 20.53s setup test_replicated_user_defined_functions/test.py::test_create_and_drop 18.95s call test_replicated_users/test.py::test_reload_zookeeper 18.93s setup test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_create_replicated_merge_tree_with_auxiliary_zookeeper 18.80s setup test_s3_imds/test_session_token.py::test_credentials_from_metadata 18.77s setup test_s3_aws_sdk_has_slightly_unreliable_behaviour/test.py::test_dataloss 18.27s setup test_postgresql_replica_database_engine_1/test.py::test_replicating_dml 16.64s call test_shutdown_wait_unfinished_queries/test.py::test_shutdown_wait_unfinished_queries 16.21s setup test_quota/test.py::test_add_remove_interval 15.97s setup test_reloading_settings_from_users_xml/test.py::test_force_reload 15.69s teardown test_replication_credentials/test.py::test_same_credentials 15.16s call test_s3_zero_copy_ttl/test.py::test_ttl_move_and_s3 14.54s setup test_ssh_keys_authentication/test.py::test_ecdsa 12.68s setup test_replicated_merge_tree_compatibility/test.py::test_replicated_merge_tree_defaults_compatibility 11.30s teardown test_replicated_mutations/test.py::test_mutations_dont_prevent_merges[nodes1] 11.24s call test_postgresql_replica_database_engine_1/test.py::test_restart_server_while_replication_startup_not_finished 11.16s teardown test_replicated_user_defined_functions/test.py::test_start_without_zookeeper 11.08s setup test_render_log_file_name_templates/test.py::test_check_file_names 10.41s teardown test_replicated_users/test.py::test_rename_replicated[USER] 9.48s setup test_shutdown_wait_unfinished_queries/test.py::test_shutdown_wait_unfinished_queries 9.28s call test_replicated_user_defined_functions/test.py::test_server_restart 8.84s teardown test_replicated_merge_tree_compatibility/test.py::test_replicated_merge_tree_defaults_compatibility 8.59s setup test_s3_with_https/test.py::test_s3_with_https[s3_secure] 7.69s call test_postgresql_replica_database_engine_1/test.py::test_single_transaction 7.03s call test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_drop_replicated_merge_tree_with_auxiliary_zookeeper 6.51s call test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_create_replicated_merge_tree_with_auxiliary_zookeeper 6.36s call test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_create_replicated_merge_tree_with_default_zookeeper 5.75s teardown test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_path_ambiguity 5.46s call test_replication_credentials/test.py::test_different_credentials 5.43s teardown test_render_log_file_name_templates/test.py::test_check_file_names 5.41s call test_quota/test.py::test_dcl_management 5.40s call test_quota/test.py::test_add_remove_interval 5.12s call test_quota/test.py::test_dcl_introspection 4.78s teardown test_replicating_constants/test.py::test_different_versions 4.44s call test_replication_credentials/test.py::test_credentials_and_no_credentials 4.42s call test_quota/test.py::test_add_remove_quota 4.41s teardown test_quota/test.py::test_users_xml_is_readonly 4.28s teardown test_reloading_settings_from_users_xml/test.py::test_unknown_setting_reload_on_timeout 4.23s call test_replicated_user_defined_functions/test.py::test_replication 4.22s teardown test_postgresql_replica_database_engine_1/test.py::test_virtual_columns 3.81s call test_quota/test.py::test_exceed_quota 3.80s teardown test_ssh_keys_authentication/test.py::test_key_with_wrong_passphrase 3.70s call test_postgresql_replica_database_engine_1/test.py::test_table_schema_changes 3.55s call test_replication_credentials/test.py::test_no_credentials 3.44s call test_quota/test.py::test_query_inserts 3.38s call test_postgresql_replica_database_engine_1/test.py::test_replicating_dml 3.37s call test_replication_credentials/test.py::test_same_credentials 3.21s call test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_path_ambiguity 2.93s call test_reloading_settings_from_users_xml/test.py::test_reload_on_timeout 2.70s call test_quota/test.py::test_reload_users_xml_by_timer 2.56s call test_replicated_merge_tree_s3_zero_copy/test.py::test_insert_select_replicated[0-16] 2.54s call test_postgresql_replica_database_engine_1/test.py::test_virtual_columns 2.46s call test_quota/test.py::test_tracking_quota 2.32s call test_quota/test.py::test_quota_from_users_xml 2.10s teardown test_shutdown_wait_unfinished_queries/test.py::test_shutdown_wait_unfinished_queries 2.05s call test_postgresql_replica_database_engine_1/test.py::test_user_managed_slots 1.99s call test_replicated_merge_tree_s3_zero_copy/test.py::test_insert_select_replicated[8192-12] 1.87s call test_replicated_merge_tree_s3_zero_copy/test.py::test_s3_check_restore 1.85s call test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[SETTINGS_PROFILE] 1.83s call test_replicated_user_defined_functions/test.py::test_create_and_replace 1.75s call test_s3_imds/test_session_token.py::test_credentials_from_metadata 1.75s call test_replicated_user_defined_functions/test.py::test_replication_replace_by_another_node_after_creation 1.68s call test_reloading_settings_from_users_xml/test.py::test_unknown_setting_reload_on_timeout 1.54s call test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[USER] 1.53s call test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[ROW_POLICY] 1.44s call test_reloading_settings_from_users_xml/test.py::test_force_reload 1.36s call test_replicated_users/test.py::test_grant_revoke_replicated[With_ignored_on_cluster] 1.35s teardown test_replicated_merge_tree_s3_zero_copy/test.py::test_insert_select_replicated[0-16] 1.33s call test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[ROLE] 1.31s teardown test_postgresql_replica_database_engine_1/test.py::test_user_managed_slots 1.30s call test_replicated_users/test.py::test_grant_revoke_replicated[Without_on_cluster] 1.28s call test_quota/test.py::test_simpliest_quota 1.28s call test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[QUOTA] 1.25s teardown test_replicated_merge_tree_s3_zero_copy/test.py::test_insert_select_replicated[8192-12] 1.21s setup test_replication_credentials/test.py::test_no_credentials 1.20s call test_replicated_users/test.py::test_create_replicated[QUOTA] 1.19s call test_reloading_settings_from_users_xml/test.py::test_unknown_setting_force_reload 1.17s setup test_quota/test.py::test_tracking_quota 1.17s call test_replicated_users/test.py::test_rename_replicated[ROLE] 1.15s call test_replicated_users/test.py::test_create_replicated[ROLE] 1.15s call test_replicated_users/test.py::test_create_replicated[USER] 1.15s call test_replicated_users/test.py::test_create_replicated[SETTINGS_PROFILE] 1.10s call test_replicated_users/test.py::test_create_replicated[ROW_POLICY] 1.08s teardown test_postgresql_replica_database_engine_1/test.py::test_restart_server_while_replication_startup_not_finished 1.05s call test_replicated_users/test.py::test_rename_replicated[QUOTA] 1.03s setup test_quota/test.py::test_reload_users_xml_by_timer 1.01s teardown test_replicated_merge_tree_s3_zero_copy/test.py::test_drop_table 0.99s call test_replicated_users/test.py::test_create_replicated_on_cluster[ROW_POLICY] 0.97s setup test_quota/test.py::test_dcl_introspection 0.95s setup test_quota/test.py::test_query_inserts 0.93s teardown test_postgresql_replica_database_engine_1/test.py::test_table_schema_changes 0.93s call test_reloading_settings_from_users_xml/test.py::test_unexpected_setting_enum 0.91s call test_replicated_users/test.py::test_rename_replicated[ROW_POLICY] 0.88s setup test_quota/test.py::test_simpliest_quota 0.88s teardown test_postgresql_replica_database_engine_1/test.py::test_single_transaction 0.88s setup test_quota/test.py::test_dcl_management 0.88s setup test_quota/test.py::test_quota_from_users_xml 0.87s call test_s3_with_https/test.py::test_s3_with_https[s3_secure_with_proxy] 0.87s setup test_quota/test.py::test_exceed_quota 0.85s setup test_quota/test.py::test_consumption_of_show_privileges 0.82s call test_replicated_user_defined_functions/test.py::test_create_and_drop_udf_on_cluster[true-expected_raise0] 0.82s teardown test_postgresql_replica_database_engine_1/test.py::test_replicating_dml 0.78s call test_reloading_settings_from_users_xml/test.py::test_unexpected_setting_int 0.78s setup test_replication_credentials/test.py::test_same_credentials 0.77s setup test_quota/test.py::test_add_remove_quota 0.76s call test_s3_with_https/test.py::test_s3_with_https[s3_secure] 0.76s setup test_quota/test.py::test_consumption_of_show_tables 0.75s setup test_quota/test.py::test_consumption_of_show_clusters 0.74s setup test_quota/test.py::test_consumption_of_show_databases 0.73s call test_replicated_users/test.py::test_create_replicated_on_cluster[SETTINGS_PROFILE] 0.73s call test_replicated_users/test.py::test_create_and_delete_replicated[USER] 0.73s setup test_quota/test.py::test_consumption_of_show_processlist 0.73s setup test_quota/test.py::test_users_xml_is_readonly 0.71s call test_replicated_users/test.py::test_rename_replicated[SETTINGS_PROFILE] 0.71s call test_replicated_users/test.py::test_rename_replicated[USER] 0.71s call test_replicated_user_defined_functions/test.py::test_drop_if_exists 0.69s call test_replicated_users/test.py::test_create_replicated_on_cluster[ROLE] 0.60s setup test_replication_credentials/test.py::test_different_credentials 0.60s call test_replicated_users/test.py::test_create_replicated_on_cluster[QUOTA] 0.53s call test_replicated_users/test.py::test_create_replicated_on_cluster[USER] 0.52s call test_ssh_keys_authentication/test.py::test_key_with_wrong_passphrase 0.50s call test_replicated_user_defined_functions/test.py::test_create_and_drop 0.49s call test_replicated_user_defined_functions/test.py::test_create_and_drop_udf_on_cluster[false-expected_raise1] 0.48s call test_quota/test.py::test_consumption_of_show_clusters 0.48s call test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_create_replicated_merge_tree_with_not_exists_auxiliary_zookeeper 0.48s call test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[QUOTA] 0.48s call test_quota/test.py::test_consumption_of_show_privileges 0.44s call test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[ROW_POLICY] 0.43s call test_render_log_file_name_templates/test.py::test_check_file_names 0.43s call test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[ROLE] 0.43s call test_quota/test.py::test_consumption_of_show_processlist 0.43s call test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[SETTINGS_PROFILE] 0.43s call test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[USER] 0.38s call test_replicated_users/test.py::test_create_and_delete_replicated[SETTINGS_PROFILE] 0.38s call test_quota/test.py::test_consumption_of_show_tables 0.38s call test_replicated_users/test.py::test_create_and_delete_replicated[QUOTA] 0.37s call test_ssh_keys_authentication/test.py::test_key_with_passphrase 0.33s call test_replicated_users/test.py::test_create_and_delete_replicated[ROLE] 0.33s call test_quota/test.py::test_consumption_of_show_databases 0.33s call test_replicated_users/test.py::test_create_and_delete_replicated[ROW_POLICY] 0.33s setup test_reloading_settings_from_users_xml/test.py::test_unknown_setting_force_reload 0.28s setup test_reloading_settings_from_users_xml/test.py::test_unknown_setting_reload_on_timeout 0.28s setup test_reloading_settings_from_users_xml/test.py::test_unexpected_setting_int 0.28s setup test_reloading_settings_from_users_xml/test.py::test_unexpected_setting_enum 0.28s setup test_reloading_settings_from_users_xml/test.py::test_reload_on_timeout 0.27s call test_replicating_constants/test.py::test_different_versions 0.22s call test_quota/test.py::test_users_xml_is_readonly 0.17s call test_ssh_keys_authentication/test.py::test_ecdsa 0.17s call test_ssh_keys_authentication/test.py::test_ed25519 0.00s setup test_replicated_user_defined_functions/test.py::test_replication 0.00s setup test_replicated_merge_tree_s3_zero_copy/test.py::test_insert_select_replicated[0-16] 0.00s setup test_replicated_mutations/test.py::test_mutations_dont_prevent_merges[nodes0] 0.00s teardown test_replicated_mutations/test.py::test_mutations 0.00s teardown test_replicated_user_defined_functions/test.py::test_reload_zookeeper 0.00s setup test_replicated_users/test.py::test_create_and_delete_replicated[SETTINGS_PROFILE] 0.00s setup test_replicated_users/test.py::test_rename_replicated[ROW_POLICY] 0.00s setup test_replicated_users/test.py::test_grant_revoke_replicated[Without_on_cluster] 0.00s teardown test_replicated_user_defined_functions/test.py::test_create_and_drop 0.00s teardown test_replicated_users/test.py::test_create_and_delete_replicated[QUOTA] 0.00s teardown test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_drop_replicated_merge_tree_with_auxiliary_zookeeper 0.00s setup test_replicated_users/test.py::test_create_and_delete_replicated[ROLE] 0.00s teardown test_replicated_mutations/test.py::test_mutations_dont_prevent_merges[nodes0] 0.00s setup test_replicated_users/test.py::test_create_replicated_on_cluster[ROW_POLICY] 0.00s setup test_replicated_user_defined_functions/test.py::test_create_and_drop_udf_on_cluster[false-expected_raise1] 0.00s setup test_postgresql_replica_database_engine_1/test.py::test_single_transaction 0.00s teardown test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_create_replicated_merge_tree_with_auxiliary_zookeeper 0.00s setup test_replicated_user_defined_functions/test.py::test_reload_zookeeper 0.00s setup test_replicated_users/test.py::test_rename_replicated[QUOTA] 0.00s teardown test_replication_credentials/test.py::test_credentials_and_no_credentials 0.00s setup test_replicated_merge_tree_s3_zero_copy/test.py::test_insert_select_replicated[8192-12] 0.00s setup test_postgresql_replica_database_engine_1/test.py::test_restart_server_while_replication_startup_not_finished 0.00s teardown test_s3_with_https/test.py::test_s3_with_https[s3_secure] 0.00s setup test_postgresql_replica_database_engine_1/test.py::test_table_schema_changes 0.00s teardown test_replicated_users/test.py::test_reload_zookeeper 0.00s setup test_replicated_user_defined_functions/test.py::test_create_and_drop_udf_on_cluster[true-expected_raise0] 0.00s setup test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_create_replicated_merge_tree_with_default_zookeeper 0.00s setup test_replicated_users/test.py::test_create_replicated[USER] 0.00s setup test_s3_with_https/test.py::test_s3_with_https[s3_secure_with_proxy] 0.00s setup test_postgresql_replica_database_engine_1/test.py::test_virtual_columns 0.00s setup test_postgresql_replica_database_engine_1/test.py::test_user_managed_slots 0.00s setup test_replicated_user_defined_functions/test.py::test_create_and_replace 0.00s setup test_replicated_merge_tree_s3_zero_copy/test.py::test_s3_check_restore 0.00s setup test_replicated_users/test.py::test_create_replicated_on_cluster[ROLE] 0.00s setup test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[ROLE] 0.00s teardown test_replicated_users/test.py::test_grant_revoke_replicated[With_ignored_on_cluster] 0.00s setup test_replicated_users/test.py::test_create_replicated[SETTINGS_PROFILE] 0.00s setup test_replicated_users/test.py::test_create_replicated[QUOTA] 0.00s setup test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[USER] 0.00s teardown test_quota/test.py::test_query_inserts 0.00s setup test_ssh_keys_authentication/test.py::test_key_with_passphrase 0.00s setup test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[ROW_POLICY] 0.00s teardown test_replicated_user_defined_functions/test.py::test_drop_if_exists 0.00s teardown test_ssh_keys_authentication/test.py::test_ed25519 0.00s setup test_replicated_users/test.py::test_create_replicated_on_cluster[SETTINGS_PROFILE] 0.00s setup test_replicated_users/test.py::test_create_replicated[ROW_POLICY] 0.00s setup test_ssh_keys_authentication/test.py::test_key_with_wrong_passphrase 0.00s setup test_replicated_users/test.py::test_create_and_delete_replicated[ROW_POLICY] 0.00s teardown test_replicated_users/test.py::test_create_and_delete_replicated[ROLE] 0.00s teardown test_replicated_user_defined_functions/test.py::test_create_and_drop_udf_on_cluster[true-expected_raise0] 0.00s setup test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_drop_replicated_merge_tree_with_auxiliary_zookeeper 0.00s setup test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[ROW_POLICY] 0.00s setup test_replicated_users/test.py::test_create_replicated_on_cluster[USER] 0.00s setup test_replicated_user_defined_functions/test.py::test_start_without_zookeeper 0.00s teardown test_reloading_settings_from_users_xml/test.py::test_reload_on_timeout 0.00s teardown test_replicated_users/test.py::test_create_and_delete_replicated[ROW_POLICY] 0.00s setup test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[USER] 0.00s setup test_replicated_users/test.py::test_create_replicated[ROLE] 0.00s setup test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[QUOTA] 0.00s teardown test_replicated_users/test.py::test_create_replicated[ROW_POLICY] 0.00s setup test_replicated_mutations/test.py::test_mutations_dont_prevent_merges[nodes1] 0.00s setup test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[ROLE] 0.00s setup test_replicated_users/test.py::test_rename_replicated[ROLE] 0.00s teardown test_replication_credentials/test.py::test_different_credentials 0.00s teardown test_replicated_users/test.py::test_create_replicated_on_cluster[QUOTA] 0.00s teardown test_quota/test.py::test_add_remove_quota 0.00s setup test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[SETTINGS_PROFILE] 0.00s teardown test_replicated_users/test.py::test_rename_replicated[ROLE] 0.00s setup test_replicated_users/test.py::test_create_and_delete_replicated[USER] 0.00s setup test_ssh_keys_authentication/test.py::test_ed25519 0.00s setup test_replicated_users/test.py::test_grant_revoke_replicated[With_ignored_on_cluster] 0.00s teardown test_replicated_users/test.py::test_create_replicated[ROLE] 0.00s teardown test_quota/test.py::test_add_remove_interval 0.00s setup test_replicated_users/test.py::test_rename_replicated[USER] 0.00s teardown test_quota/test.py::test_consumption_of_show_clusters 0.00s teardown test_replicated_users/test.py::test_create_replicated[USER] 0.00s setup test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[QUOTA] 0.00s teardown test_quota/test.py::test_consumption_of_show_privileges 0.00s teardown test_replicated_users/test.py::test_rename_replicated[QUOTA] 0.00s setup test_replicated_users/test.py::test_rename_replicated[SETTINGS_PROFILE] 0.00s setup test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[SETTINGS_PROFILE] 0.00s teardown test_ssh_keys_authentication/test.py::test_ecdsa 0.00s setup test_replicated_users/test.py::test_create_replicated_on_cluster[QUOTA] 0.00s teardown test_quota/test.py::test_simpliest_quota 0.00s teardown test_replicated_users/test.py::test_create_replicated[SETTINGS_PROFILE] 0.00s teardown test_reloading_settings_from_users_xml/test.py::test_force_reload 0.00s setup test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_path_ambiguity 0.00s setup test_replicated_user_defined_functions/test.py::test_replication_replace_by_another_node_after_creation 0.00s teardown test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[QUOTA] 0.00s setup test_replicated_user_defined_functions/test.py::test_server_restart 0.00s teardown test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[USER] 0.00s teardown test_replicated_user_defined_functions/test.py::test_create_and_drop_udf_on_cluster[false-expected_raise1] 0.00s teardown test_replicated_user_defined_functions/test.py::test_server_restart 0.00s teardown test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[ROLE] 0.00s teardown test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[SETTINGS_PROFILE] 0.00s setup test_replicated_user_defined_functions/test.py::test_drop_if_exists 0.00s teardown test_quota/test.py::test_consumption_of_show_tables 0.00s teardown test_quota/test.py::test_consumption_of_show_databases 0.00s teardown test_replicated_users/test.py::test_create_and_delete_replicated[SETTINGS_PROFILE] 0.00s teardown test_quota/test.py::test_dcl_management 0.00s setup test_replicated_users/test.py::test_reload_zookeeper 0.00s teardown test_replicated_users/test.py::test_create_and_delete_replicated[USER] 0.00s teardown test_reloading_settings_from_users_xml/test.py::test_unknown_setting_force_reload 0.00s teardown test_reloading_settings_from_users_xml/test.py::test_unexpected_setting_int 0.00s teardown test_reloading_settings_from_users_xml/test.py::test_unexpected_setting_enum 0.00s teardown test_quota/test.py::test_quota_from_users_xml 0.00s teardown test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[ROLE] 0.00s teardown test_replicated_users/test.py::test_create_replicated_on_cluster[ROLE] 0.00s teardown test_replicated_users/test.py::test_create_replicated_on_cluster[SETTINGS_PROFILE] 0.00s setup test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_create_replicated_merge_tree_with_not_exists_auxiliary_zookeeper 0.00s teardown test_replicated_users/test.py::test_create_replicated[QUOTA] 0.00s teardown test_quota/test.py::test_reload_users_xml_by_timer 0.00s teardown test_replicated_users/test.py::test_create_replicated_on_cluster[ROW_POLICY] 0.00s teardown test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[QUOTA] 0.00s teardown test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[ROW_POLICY] 0.00s teardown test_quota/test.py::test_tracking_quota 0.00s teardown test_replicated_users/test.py::test_grant_revoke_replicated[Without_on_cluster] 0.00s teardown test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[SETTINGS_PROFILE] 0.00s teardown test_quota/test.py::test_dcl_introspection 0.00s teardown test_quota/test.py::test_consumption_of_show_processlist 0.00s teardown test_replicated_users/test.py::test_rename_replicated[ROW_POLICY] 0.00s teardown test_replicated_user_defined_functions/test.py::test_replication 0.00s teardown test_replicated_users/test.py::test_rename_replicated[SETTINGS_PROFILE] 0.00s teardown test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[USER] 0.00s teardown test_ssh_keys_authentication/test.py::test_key_with_passphrase 0.00s teardown test_replication_credentials/test.py::test_no_credentials 0.00s teardown test_replicated_users/test.py::test_create_replicated_on_cluster[USER] 0.00s teardown test_replicated_user_defined_functions/test.py::test_replication_replace_by_another_node_after_creation 0.00s teardown test_quota/test.py::test_exceed_quota 0.00s teardown test_replicated_user_defined_functions/test.py::test_create_and_replace 0.00s teardown test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_create_replicated_merge_tree_with_default_zookeeper 0.00s teardown test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[ROW_POLICY] 0.00s teardown test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_create_replicated_merge_tree_with_not_exists_auxiliary_zookeeper =========================== short test summary info ============================ FAILED test_postgresql_replica_database_engine_1/test.py::test_replicating_dml FAILED test_postgresql_replica_database_engine_1/test.py::test_restart_server_while_replication_startup_not_finished FAILED test_postgresql_replica_database_engine_1/test.py::test_single_transaction FAILED test_postgresql_replica_database_engine_1/test.py::test_table_schema_changes FAILED test_postgresql_replica_database_engine_1/test.py::test_user_managed_slots FAILED test_postgresql_replica_database_engine_1/test.py::test_virtual_columns PASSED test_ssh_keys_authentication/test.py::test_ecdsa PASSED test_ssh_keys_authentication/test.py::test_ed25519 PASSED test_ssh_keys_authentication/test.py::test_key_with_passphrase PASSED test_ssh_keys_authentication/test.py::test_key_with_wrong_passphrase PASSED test_reloading_settings_from_users_xml/test.py::test_force_reload PASSED test_reloading_settings_from_users_xml/test.py::test_reload_on_timeout PASSED test_replicated_user_defined_functions/test.py::test_create_and_drop PASSED test_replicated_user_defined_functions/test.py::test_create_and_drop_udf_on_cluster[false-expected_raise1] PASSED test_quota/test.py::test_add_remove_interval PASSED test_reloading_settings_from_users_xml/test.py::test_unexpected_setting_enum PASSED test_replicated_users/test.py::test_create_and_delete_replicated[QUOTA] PASSED test_replicated_user_defined_functions/test.py::test_create_and_drop_udf_on_cluster[true-expected_raise0] PASSED test_replicated_users/test.py::test_create_and_delete_replicated[ROLE] PASSED test_replicated_users/test.py::test_create_and_delete_replicated[ROW_POLICY] PASSED test_reloading_settings_from_users_xml/test.py::test_unexpected_setting_int PASSED test_replicated_users/test.py::test_create_and_delete_replicated[SETTINGS_PROFILE] PASSED test_replicated_users/test.py::test_create_and_delete_replicated[USER] PASSED test_replicated_user_defined_functions/test.py::test_create_and_replace PASSED test_reloading_settings_from_users_xml/test.py::test_unknown_setting_force_reload PASSED test_replicated_user_defined_functions/test.py::test_drop_if_exists PASSED test_replicated_users/test.py::test_create_replicated[QUOTA] PASSED test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_create_replicated_merge_tree_with_auxiliary_zookeeper PASSED test_replicated_users/test.py::test_create_replicated[ROLE] PASSED test_reloading_settings_from_users_xml/test.py::test_unknown_setting_reload_on_timeout PASSED test_quota/test.py::test_add_remove_quota PASSED test_replicated_users/test.py::test_create_replicated[ROW_POLICY] PASSED test_quota/test.py::test_consumption_of_show_clusters PASSED test_replicated_users/test.py::test_create_replicated[SETTINGS_PROFILE] PASSED test_s3_with_https/test.py::test_s3_with_https[s3_secure] PASSED test_quota/test.py::test_consumption_of_show_databases PASSED test_replicated_users/test.py::test_create_replicated[USER] PASSED test_s3_with_https/test.py::test_s3_with_https[s3_secure_with_proxy] PASSED test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[QUOTA] PASSED test_quota/test.py::test_consumption_of_show_privileges PASSED test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[ROLE] PASSED test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[ROW_POLICY] PASSED test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[SETTINGS_PROFILE] PASSED test_quota/test.py::test_consumption_of_show_processlist PASSED test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_create_replicated_merge_tree_with_default_zookeeper PASSED test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[USER] PASSED test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_create_replicated_merge_tree_with_not_exists_auxiliary_zookeeper PASSED test_replicated_users/test.py::test_create_replicated_on_cluster[QUOTA] PASSED test_quota/test.py::test_consumption_of_show_tables PASSED test_replicated_users/test.py::test_create_replicated_on_cluster[ROLE] PASSED test_replicated_users/test.py::test_create_replicated_on_cluster[ROW_POLICY] PASSED test_replicated_users/test.py::test_create_replicated_on_cluster[SETTINGS_PROFILE] PASSED test_replicated_users/test.py::test_create_replicated_on_cluster[USER] PASSED test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[QUOTA] PASSED test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[ROLE] PASSED test_quota/test.py::test_dcl_introspection PASSED test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_drop_replicated_merge_tree_with_auxiliary_zookeeper PASSED test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[ROW_POLICY] PASSED test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[SETTINGS_PROFILE] PASSED test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_path_ambiguity PASSED test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[USER] PASSED test_replicated_users/test.py::test_grant_revoke_replicated[With_ignored_on_cluster] PASSED test_quota/test.py::test_dcl_management PASSED test_replicated_users/test.py::test_grant_revoke_replicated[Without_on_cluster] PASSED test_replication_credentials/test.py::test_credentials_and_no_credentials PASSED test_quota/test.py::test_exceed_quota PASSED test_replicated_user_defined_functions/test.py::test_reload_zookeeper PASSED test_replication_credentials/test.py::test_different_credentials PASSED test_quota/test.py::test_query_inserts PASSED test_replicated_user_defined_functions/test.py::test_replication PASSED test_quota/test.py::test_quota_from_users_xml PASSED test_replication_credentials/test.py::test_no_credentials PASSED test_replicated_user_defined_functions/test.py::test_replication_replace_by_another_node_after_creation PASSED test_quota/test.py::test_reload_users_xml_by_timer PASSED test_replication_credentials/test.py::test_same_credentials PASSED test_quota/test.py::test_simpliest_quota PASSED test_replicated_users/test.py::test_reload_zookeeper PASSED test_render_log_file_name_templates/test.py::test_check_file_names PASSED test_replicated_users/test.py::test_rename_replicated[QUOTA] PASSED test_replicated_users/test.py::test_rename_replicated[ROLE] PASSED test_quota/test.py::test_tracking_quota PASSED test_replicated_mutations/test.py::test_mutations PASSED test_replicated_user_defined_functions/test.py::test_server_restart PASSED test_replicated_users/test.py::test_rename_replicated[ROW_POLICY] PASSED test_quota/test.py::test_users_xml_is_readonly PASSED test_replicated_users/test.py::test_rename_replicated[SETTINGS_PROFILE] PASSED test_replicated_users/test.py::test_rename_replicated[USER] PASSED test_replicated_merge_tree_compatibility/test.py::test_replicated_merge_tree_defaults_compatibility PASSED test_replicated_merge_tree_s3_zero_copy/test.py::test_drop_table PASSED test_replicated_merge_tree_s3_zero_copy/test.py::test_insert_select_replicated[0-16] PASSED test_replicated_merge_tree_s3_zero_copy/test.py::test_insert_select_replicated[8192-12] PASSED test_replicated_merge_tree_s3_zero_copy/test.py::test_s3_check_restore PASSED test_s3_zero_copy_ttl/test.py::test_ttl_move_and_s3 PASSED test_replicated_user_defined_functions/test.py::test_start_without_zookeeper PASSED test_replicating_constants/test.py::test_different_versions PASSED test_replicated_mutations/test.py::test_mutations_dont_prevent_merges[nodes0] PASSED test_s3_imds/test_session_token.py::test_credentials_from_metadata PASSED test_shutdown_wait_unfinished_queries/test.py::test_shutdown_wait_unfinished_queries PASSED test_replicated_mutations/test.py::test_mutations_dont_prevent_merges[nodes1] PASSED test_s3_aws_sdk_has_slightly_unreliable_behaviour/test.py::test_dataloss ============= 6 failed, 94 passed, 1 warning in 413.95s (0:06:53) ============== Traceback (most recent call last): File "/home/ubuntu/_work/ClickHouse/ClickHouse/tests/integration/./runner", line 437, in subprocess.check_call(cmd, shell=True) File "/usr/lib/python3.10/subprocess.py", line 369, in check_call raise CalledProcessError(retcode, cmd) subprocess.CalledProcessError: Command 'docker run --rm --name clickhouse_integration_tests_5ciz2o --privileged --dns-search='.' --volume=/home/ubuntu/_work/_temp/test/build/clickhouse-odbc-bridge:/clickhouse-odbc-bridge --volume=/home/ubuntu/_work/_temp/test/build/clickhouse:/clickhouse --volume=/home/ubuntu/_work/_temp/test/build/clickhouse-library-bridge:/clickhouse-library-bridge --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/programs/server:/clickhouse-config --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/tests/integration:/ClickHouse/tests/integration --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/utils/backupview:/ClickHouse/utils/backupview --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/utils/grpc-client/pb2:/ClickHouse/utils/grpc-client/pb2 --volume=/run:/run/host:ro --volume=clickhouse_integration_tests_volume:/var/lib/docker -e DOCKER_DOTNET_CLIENT_TAG=11de0b29a15d -e DOCKER_HELPER_TAG=2cffe1eae894 -e DOCKER_BASE_TAG=2993bc2bf171 -e DOCKER_KERBERIZED_HADOOP_TAG=ce74919e88f5 -e DOCKER_KERBEROS_KDC_TAG=9391ecdee8d7 -e DOCKER_MYSQL_GOLANG_CLIENT_TAG=9bec2a638e6e -e DOCKER_MYSQL_JAVA_CLIENT_TAG=766bff31cfe4 -e DOCKER_MYSQL_JS_CLIENT_TAG=41ba7c2ec2a1 -e DOCKER_MYSQL_PHP_CLIENT_TAG=88be89c1e3b6 -e DOCKER_NGINX_DAV_TAG=b55ac9cd7519 -e DOCKER_POSTGRESQL_JAVA_CLIENT_TAG=a4eff5c7f4d6 -e DOCKER_PYTHON_BOTTLE_TAG=a2d3dc777d0c -e DOCKER_CLIENT_TIMEOUT=300 -e COMPOSE_HTTP_TIMEOUT=600 -e CLICKHOUSE_USE_OLD_ANALYZER=1 -e PYTHONUNBUFFERED=1 -e PYTEST_ADDOPTS="--dist=loadfile -n 10 -rfEps --run-id=0 --color=no --durations=0 test_postgresql_replica_database_engine_1/test.py::test_replicating_dml test_postgresql_replica_database_engine_1/test.py::test_restart_server_while_replication_startup_not_finished test_postgresql_replica_database_engine_1/test.py::test_single_transaction test_postgresql_replica_database_engine_1/test.py::test_table_schema_changes test_postgresql_replica_database_engine_1/test.py::test_user_managed_slots test_postgresql_replica_database_engine_1/test.py::test_virtual_columns test_quota/test.py::test_add_remove_interval test_quota/test.py::test_add_remove_quota test_quota/test.py::test_consumption_of_show_clusters test_quota/test.py::test_consumption_of_show_databases test_quota/test.py::test_consumption_of_show_privileges test_quota/test.py::test_consumption_of_show_processlist test_quota/test.py::test_consumption_of_show_tables test_quota/test.py::test_dcl_introspection test_quota/test.py::test_dcl_management test_quota/test.py::test_exceed_quota test_quota/test.py::test_query_inserts test_quota/test.py::test_quota_from_users_xml test_quota/test.py::test_reload_users_xml_by_timer test_quota/test.py::test_simpliest_quota test_quota/test.py::test_tracking_quota test_quota/test.py::test_users_xml_is_readonly test_reloading_settings_from_users_xml/test.py::test_force_reload test_reloading_settings_from_users_xml/test.py::test_reload_on_timeout test_reloading_settings_from_users_xml/test.py::test_unexpected_setting_enum test_reloading_settings_from_users_xml/test.py::test_unexpected_setting_int test_reloading_settings_from_users_xml/test.py::test_unknown_setting_force_reload test_reloading_settings_from_users_xml/test.py::test_unknown_setting_reload_on_timeout test_render_log_file_name_templates/test.py::test_check_file_names test_replicated_merge_tree_compatibility/test.py::test_replicated_merge_tree_defaults_compatibility test_replicated_merge_tree_s3_zero_copy/test.py::test_drop_table 'test_replicated_merge_tree_s3_zero_copy/test.py::test_insert_select_replicated[0-16]' 'test_replicated_merge_tree_s3_zero_copy/test.py::test_insert_select_replicated[8192-12]' test_replicated_merge_tree_s3_zero_copy/test.py::test_s3_check_restore test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_create_replicated_merge_tree_with_auxiliary_zookeeper test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_create_replicated_merge_tree_with_default_zookeeper test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_create_replicated_merge_tree_with_not_exists_auxiliary_zookeeper test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_drop_replicated_merge_tree_with_auxiliary_zookeeper test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_path_ambiguity test_replicated_mutations/test.py::test_mutations 'test_replicated_mutations/test.py::test_mutations_dont_prevent_merges[nodes0]' 'test_replicated_mutations/test.py::test_mutations_dont_prevent_merges[nodes1]' test_replicated_user_defined_functions/test.py::test_create_and_drop 'test_replicated_user_defined_functions/test.py::test_create_and_drop_udf_on_cluster[false-expected_raise1]' 'test_replicated_user_defined_functions/test.py::test_create_and_drop_udf_on_cluster[true-expected_raise0]' test_replicated_user_defined_functions/test.py::test_create_and_replace test_replicated_user_defined_functions/test.py::test_drop_if_exists test_replicated_user_defined_functions/test.py::test_reload_zookeeper test_replicated_user_defined_functions/test.py::test_replication test_replicated_user_defined_functions/test.py::test_replication_replace_by_another_node_after_creation test_replicated_user_defined_functions/test.py::test_server_restart test_replicated_user_defined_functions/test.py::test_start_without_zookeeper 'test_replicated_users/test.py::test_create_and_delete_replicated[QUOTA]' 'test_replicated_users/test.py::test_create_and_delete_replicated[ROLE]' 'test_replicated_users/test.py::test_create_and_delete_replicated[ROW_POLICY]' 'test_replicated_users/test.py::test_create_and_delete_replicated[SETTINGS_PROFILE]' 'test_replicated_users/test.py::test_create_and_delete_replicated[USER]' 'test_replicated_users/test.py::test_create_replicated[QUOTA]' 'test_replicated_users/test.py::test_create_replicated[ROLE]' 'test_replicated_users/test.py::test_create_replicated[ROW_POLICY]' 'test_replicated_users/test.py::test_create_replicated[SETTINGS_PROFILE]' 'test_replicated_users/test.py::test_create_replicated[USER]' 'test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[QUOTA]' 'test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[ROLE]' 'test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[ROW_POLICY]' 'test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[SETTINGS_PROFILE]' 'test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[USER]' 'test_replicated_users/test.py::test_create_replicated_on_cluster[QUOTA]' 'test_replicated_users/test.py::test_create_replicated_on_cluster[ROLE]' 'test_replicated_users/test.py::test_create_replicated_on_cluster[ROW_POLICY]' 'test_replicated_users/test.py::test_create_replicated_on_cluster[SETTINGS_PROFILE]' 'test_replicated_users/test.py::test_create_replicated_on_cluster[USER]' 'test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[QUOTA]' 'test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[ROLE]' 'test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[ROW_POLICY]' 'test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[SETTINGS_PROFILE]' 'test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[USER]' 'test_replicated_users/test.py::test_grant_revoke_replicated[With_ignored_on_cluster]' 'test_replicated_users/test.py::test_grant_revoke_replicated[Without_on_cluster]' test_replicated_users/test.py::test_reload_zookeeper 'test_replicated_users/test.py::test_rename_replicated[QUOTA]' 'test_replicated_users/test.py::test_rename_replicated[ROLE]' 'test_replicated_users/test.py::test_rename_replicated[ROW_POLICY]' 'test_replicated_users/test.py::test_rename_replicated[SETTINGS_PROFILE]' 'test_replicated_users/test.py::test_rename_replicated[USER]' test_replicating_constants/test.py::test_different_versions test_replication_credentials/test.py::test_credentials_and_no_credentials test_replication_credentials/test.py::test_different_credentials test_replication_credentials/test.py::test_no_credentials test_replication_credentials/test.py::test_same_credentials test_s3_aws_sdk_has_slightly_unreliable_behaviour/test.py::test_dataloss test_s3_imds/test_session_token.py::test_credentials_from_metadata 'test_s3_with_https/test.py::test_s3_with_https[s3_secure]' 'test_s3_with_https/test.py::test_s3_with_https[s3_secure_with_proxy]' test_s3_zero_copy_ttl/test.py::test_ttl_move_and_s3 test_shutdown_wait_unfinished_queries/test.py::test_shutdown_wait_unfinished_queries test_ssh_keys_authentication/test.py::test_ecdsa test_ssh_keys_authentication/test.py::test_ed25519 test_ssh_keys_authentication/test.py::test_key_with_passphrase test_ssh_keys_authentication/test.py::test_key_with_wrong_passphrase -vvv" altinityinfra/integration-tests-runner:9d492c2eec24 ' returned non-zero exit status 1.